SQL & PL/SQL

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!

better than using substr and instr

994122Dec 29 2014 — edited Dec 30 2014

Hi all,

can you please give me better than this Query??

SELECT Ltrim(Rtrim(Substr(str, 1, Instr(str, ',', 1, 1) - 1)))

FROM dual

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2015

Added on Dec 29 2014

9 comments

618 views