Well, well, well!
It's Menaka! Hehe. How have you been? The code below may be of help
to you! Hehe.


set lines 132

with data
as
(
select myvalues, row_number() over (order by myvalues) rn,
count(*) over () cnt
from
(
select ename myvalues from emp
)
)
select ltrim(sys_connect_by_path(myvalues, ','),',') as catvalues
from data
where rn = cnt
start with rn = 1
connect by prior rn = rn-1
/





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Menaka
[mailto:oracledba-ezmlmshield-x33363004.[Email address protected]
Sent: Wednesday, April 02, 2008 5:51 AM
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