Menaka,



You can use this concept and get your result...



declare

IN_string varchar2(30) := 'aaa,bbb,ccc,ddd';

c_length number(7);

f_string varchar2(30);

begin



select length(trim(translate(IN_string,'abcd',' '))) INTO c_length from
dual;

if c_length >=3 then

f_string := IN_string || '...' ;

end if;

dbms_output.put_line('Formated String is :' || f_string);

end;

/





Regards,

Siva.P

Bangalore





-----Original Message-----
From: Menaka
[mailto:oracledba-ezmlmshield-x33363004.[Email address protected]
Sent: Wednesday, April 02, 2008 3:21 PM
To: LazyDBA Discussion
Subject: need code



Hai DBA's

In my table one column has value like aaa,bbb,ccc,ddd,eee like
that.in that after 3 commas i will display like aaa,bbb,ccc...

can you please tell me the code

Thanks

Menaka





---------------------------------------------------------------------

TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY

To post a dba job: http://jobs.lazydba.com

To Subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html








Oracle LazyDBA home page