How to display the whole database content without knowing all of the structure?

NodeReaper has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How to display the whole database content without knowing all of the structure? by OM_Zen (Scribe) on Jan 09, 2003 at 18:33 UTC
Hi , `my $tables = "select column_name ,object_name from all_tab_colum +ns,dba_objects where owner_name = ? and column_name in (select colum +n_name from all_tab_columns where table_name = object_name)";` [download] This is a correlated subselect ,so it takes time,it can be optimized.	[reply] [d/l]