Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncating String in Sql Query

594768Sep 18 2007 — edited Sep 18 2007

Hi,

I'm having one location table where the values of location are returned as KC_KansasCity,CHAR_Charlotte,PEW_Pewauke etc,I want to truncate the characters before underscore and also underscore while inserting the data into table.

Can anybody advise me on how to do this..

Thanks,
Anil

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2007

Added on Sep 18 2007

#application-servers, #toplink-jpa

1 comment

735 views