dashang.trivedi
Novice
May 31, 2011, 10:46 PM
Post #4 of 5
(14370 views)
|
|
Re: [FishMonger] How to get all tables name from database....
[In reply to]
|
Can't Post
|
|
hi sir thank you for replying...
I check DBI link already....and i found this way.....
i want for oracle and Postgres database
my @tables = $dbh->tables ( );
foreach $table (@tables ){
print "Table Name $table\n";
#print TXT "$table \n";
}
but this is very time consuming process ...u know any other way....????
and one more thing
In Postgres SQL i can search a pattern $dbh->tables ('','','tbl%','' );
In Oracle how this thing is done ???
(This post was edited by dashang.trivedi on May 31, 2011, 10:47 PM)
|
MAIN
SEARCH
WHO'S 
LOG 