SELECT SUBSTRING('abc(praveen)def()tutorial',INSTR('abc(praveen)def()tutorial','(',-1,1)-1,INSTR('abc(praveen)def()tutorial',')',-1,1)-1-INSTR('abc(praveen)def()tutorial','(',-1,1)-1) from DUAL;
The above query output is null
SELECT SUBSTRING('abc(praveen)def()tutorial',INSTR('abc(praveen)def()tutorial','(',-1,2)-1,INSTR('abc(praveen)def()tutorial',')',-1,2)-1-INSTR('abc(praveen)def()tutorial','(',-1,2)-1) from DUAL;
The above query output is praveen
The above query output is null
SELECT SUBSTRING('abc(praveen)def()tutorial',INSTR('abc(praveen)def()tutorial','(',-1,2)-1,INSTR('abc(praveen)def()tutorial',')',-1,2)-1-INSTR('abc(praveen)def()tutorial','(',-1,2)-1) from DUAL;
The above query output is praveen
No comments:
Post a Comment
If you Like my blog Spread it and help friends for whom this blog is useful for their career.