Hi All
I have a following query in oracle 10g
I have a clob variable which has some text like
declare
l_clob clob;
begin
l_clob:='select col1
from tab1,
tab2
where col2=col3;'
end;
now i need to search the clob variable l_clob for string 'tab2' which should have 'from' string before it.