Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Simple Oracle Script (I think)
Can anyone give help me with the syntax for a script that would loop
through all_tab_columns looking for tables that have a certain row.
While doing this, as each table name is provided (through a cursor I
imagine), I would like to query that table to see if records with a
certain primary key exist. The result would be a report to the screen
of the table names and record counts that contain the search criteria
(the PK I am searching for).
Thanks for the help. Received on Tue Oct 28 2003 - 16:01:17 CST