Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

REGEXP_INSTR

boopathiAug 23 2010 — edited Aug 23 2010
i have the following string stores in table and want found the postiotn of 0 in the string .
I know we can use REGEXP_INSTR to get the same.

Note : 0 is not fixed.

Input :

1111100

output:

1111100 6
1111100 7
This post has been answered by ©J7 on Aug 23 2010
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 20 2010
Added on Aug 23 2010
4 comments
951 views