Thanks for the question, Bhogesh.
Asked: February 16, 2017 - 5:35 pm UTC
Last updated: February 17, 2017 - 3:37 am UTC
Version: 12c
Viewed 1000+ times
SQL> with t as 2 ( select 'sdkjksdfFDOR:1234;' c from dual ) 3 select 4 rtrim(substr(c,instr(c,'FDOR:')+5),';') 5 from t; RTRI ---- 1234
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!