cursor to go thru multiple tables...
752674Feb 9 2010 — edited Feb 19 2010Hi newbie here!
I have a question reg writing a cursor n plsql block reg traverse thru dba_tables and all_tab_comments..
Here is the description:
When i write code this way: select * from all_tab_comments, i get owner,table_name, comments for diff tables, and When i write code for dba_tables like select * from dba_tables where table_name like '%something' i get many tables here, but i need to traverse thru table columns and join the above two.
select * from all tab_comments result:
owner table_name tab_comments
abc tab_1 this is table1
cde tab_2 this is table2
and when i select * from tab_1 I will get:
tab_v tab_date
1.1 08/01/2004
1.2 09/01/2004
so my final out put should be:
tab_v tab_Date tab_comments
1.1 08/01/2004 this is table1
1.2 09/01/2004 this is table2
How can i achieve this? traverse thru all tables and inside the table???