Home » RDBMS Server » Server Administration » Seeing everything
Seeing everything [message #374381] Fri, 08 June 2001 16:38 Go to next message
Tracy Reed
Messages: 1
Registered: June 2001
Junior Member
what's the statement used to view all tables from a sql prompt?

Report message to a moderator

Re: Seeing everything [message #374391 is a reply to message #374381] Sat, 09 June 2001 20:46 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
if you have dba role then.
select table_name from dba_tables;

if you don't have dba role
select table_from all_tables;

would fetch all the tables you have created plus all the tables you have been granted access....

select table_name from user_tables;

would fetch only the tables you have created.

Report message to a moderator

Previous Topic: feature not enabled:objects
Next Topic: reading a substring after you find a token
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 14:33:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.