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!
Lets consider the below text
create table xx_test (col1 varchar2(250)); insert into xx_test values ('where 1=1 order by 1 desc'); insert into xx_test values ('where 1=1');I need to extract the next word "1 desc" after 'order by' text.