Skip to Main Content

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!

REG_MATCH

7688438Jan 30 2017 — edited Jan 30 2017

Hi, Can any body provide some inputs on how to rewrite the below statement in oracle sql. REG_MATCH is informatica function. SELECT IIF(REG_MATCH(W_PARTY_PER_DS.X_IDENTITY_ID,'Person-.*')=1,SUBSTR(W_PARTY_PER_DS.X_IDENTITY_ID,8),NULL) FROM W_CASE_PER_DS; Thanks in advance Kumar

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2017
Added on Jan 30 2017
7 comments
1,206 views