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!

DBMS_LOB.instr (looking backwards for a string)

136990Jan 14 2003 — edited Jan 14 2003

I am trying to find the position of the first instance of a string ('><'), but staring at a position in the CLOB (not the start) and working backwards
I thought this may work:
num := DBMS_LOB.instr(L_CLOB, '><', 5000, -1);

But unfortunately it returns nothing....
Anyone able to help me?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 11 2003

Added on Jan 14 2003

1 comment

642 views