OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Select clause

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Select clause [message #373472]

Wed, 18 April 2001 12:09

AV
Messages: 2
Registered: April 2001

Junior Member

how do i select a table without knowing the table name.
for ex. i know that i am in a schema and i am trying to list out all the existing tables in the schema using select * from tab;
but this does not work. is there any other equal select clause where i can apply and find the table names existing in the schema

Report message to a moderator

Re: Select clause [message #373473 is a reply to message #373472]

Wed, 18 April 2001 12:45

Jaco
Messages: 23
Registered: August 2000

Junior Member

SELECT OWNER,TABLE_NAME,TABLESPACE_NAME FROM ALL_TABLES;

JACO

Report message to a moderator

Re: Select clause [message #373474 is a reply to message #373472]

Wed, 18 April 2001 12:46

Cindy
Messages: 88
Registered: November 1999

Member

Try this:

select table_name, owner from all_tables;

To exclude all system tables:
select table_name, owner from all_tables
where owner NOT like 'SYS%';

Hope this help.
--Cindy

Report message to a moderator