Of course it is possible, most things are! Assuming your value is stored
in 'val'
select decode(instr(val,',',1,3)
, 0 , val
, substr(val,1,instr(val,',',1,3)-1)||'...') from dual ;
Stephen Weston
-----Original Message-----
From: Jagdish Prajapati
[mailto:oracledba-ezmlmshield-x27821881.[Email address protected]
Sent: 02 April 2008 10:54
To: LazyDBA Discussion
Subject: Re: need code
actually it is not possible i am sorry
Jagdish Prajapati
Programmer
3i-Infotech
Andheri - Centre Point
Mobile No - 09833938434
----- Original Message -----
From: "Menaka " <oracledba-ezmlmshield-x33363004.[Email address
protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, April 02, 2008 3:20 PM
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
>
>
>
>
>
>
---
This e-mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient.If you have erroneously received this
message, please delete it immediately and notify the sender. The
recipient acknowledges that 3i Infotech or its subsidiaries and
associated companies, (collectively "3i Infotech"), are unable to
exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and
further acknowledges that any views expressed in this message are those
of the individual sender and no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects.
---------------------------------------------------------------------
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