How to truncate text stored in a column ?

I have a table (APP) containing id and remarks as follow:

1,'MRS (17/02/2010 12:05:45 PM): Before approving this application bla bla bla '
2,'ROSE (17/02/2010 12:05:45 PM): We have no objection. '
3,'DANIEL (17/02/2010 12:05:45 PM): This application is deleted from the main file. '
etc etc etc...

if I run sql command ( select id, function(remarks) from APP ), it would display

1,'Before approving this application bla bla bla'
2,'We have no objection.'
3,'This application is deleted from the main file.'

So what pl/sql code to put in the function to truncate the remarks as above ?

note : if the length of "editors" is fixed, ie, let say 20 char, then I could use
substr(remarks,21,500).

Thanks
LVL 1
KG1973Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
OH... I get it...

select substr(remarks,instr(remarks,':')+1) from table;


0
 
slightwv (䄆 Netminder) Commented:
I don't understand what you are asking.  What do you mean by truncate?

0
 
KG1973Author Commented:
slightwv,

select substr(remarks,instr(remarks,':')+11) from table;

perfect :)
thanks a million
0
All Courses

From novice to tech pro — start learning today.