Skip to Main Content

SQL & PL/SQL

Announcement

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!

cursor to go thru multiple tables...

752674Feb 9 2010 — edited Feb 19 2010
Hi 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???
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2010
Added on Feb 9 2010
7 comments
5,465 views