August 3rd, 2005, 08:13 AM
|
|
Registered User
|
|
Join Date: Aug 2005
Location: in Germany, Bavaria
Posts: 5
Time spent in forums: 1 h 28 m 41 sec
Reputation Power: 0
|
|
Code:
select count(*) from user_tables t where t.table_name = 'yourTableName'
Quote: | Originally Posted by ravi4uallin hi guys,
i have oracle 9i installed in my pc. previously i have used oracle 8i personal edition, which consited of navigator. but the version that i am using now has no navigator so i am not able to know which all tables exist in database.
i just want to know what is the command to check for existing tables in the databases.
if u know how to do it.. please reply here or mail me at ravi4uallin@yahoo.co.in. i will be greatful fo ur suggestions...
Regards,
ravio |
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
