How to get multiple like records in oracle plsql

SELECT SHORTNAME, regexp_substr(ASM_SHORTNAME,'\((.*?)\)',1,1,null,1) bracket1 FROM tblNew where regexp_like (SHORTNAME, '(RAJ|ANI|TIW|SQB|SNJ|SHO|ANU|MHN|CLS)')

0 Comments