
dashang.trivedi
Novice
May 31, 2011, 10:46 PM
Post #4 of 5
(14116 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)
|