Extracting Table names from a Select Stament

Shell Programming and Scripting
1

Hi,

I am working on a code to extract the table names out of a select statement. Is there anybody who has worked on something similar? May be you could provide me with the regular expression for the same.

Regards.

Silas

2

i didint got urs question correctly....! man

u want sql statement

fine then u can give it as

select * from all_tabs_colums where table_name ="name of the table";

sum thing like

varible name =`sqlplus -s "id"/"password" << END

set serveroutput on
select * from all_tabs_colums where table_name ="name of the table";

end'

3

Sorry for nto being very clear.

The script should:

Given a sql statement,

For Eg. select * from table1 t1, table2 t2 where .....

extract the table names from this sql statement. i. e we should be able to extract table1 and table2.

Is that fine?