SELECT str,

DECODE(SIGN(INSTR(str,',',1,3)),1,SUBSTR(str,1,INSTR(str,',',1,3)-1)||'.
..',str) formatted_str
FROM (
SELECT 'aaa' str FROM DUAL UNION ALL
SELECT 'aaa,bbb' str FROM DUAL UNION ALL
SELECT 'aaa,bbb,ccc' str FROM DUAL UNION ALL
SELECT 'aaa,bbb,ccc,ddd' str FROM DUAL UNION ALL
SELECT 'aaa,bbb,ccc,ddd,eee' str FROM DUAL UNION ALL
SELECT 'aaa,bbb,ccc,ddd,eee,fff' str FROM DUAL UNION ALL
SELECT '' str FROM DUAL
) a
;

-----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

Oracle LazyDBA home page