Hi Team,
I am using Oracle 11g.
I have a column in a table where string values are stored as SELECT stmnt-
I have a requirement to extract only the table names used in the select statements ( including schema tabes too) basically to pull out the string between FROM and WHERE.
with tbl as (
select 'select * from cc where customer_id in (123)' from dual union all
select 'select * from mbs.email_address where customer_id in (123)' from dual union all
select 'select * from kreddy.transactions where customer_id in (123)' from dual
)