CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI: Re: [FishMonger] How to get all tables name from database....: Edit Log



dashang.trivedi
Novice

May 31, 2011, 10:46 PM


Views: 7770
Re: [FishMonger] How to get all tables name from database....

hi sir thank you for replying...

I check DBI link already....and i found this way.....
i want for oracle and Postgres database

Code
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)


Edit Log:
Post edited by dashang.trivedi (Novice) on May 31, 2011, 10:47 PM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives