If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Quick SQL Question

gerTheGreat · 2005-11-23 09:57:32

Is there any way to view all of the table/ views/etc that you've created in an Oracle db? If so, how? Thanks Ger...

Options

23-11-2005 10:57am

#1

gerTheGreat

Registered Users Posts: 871 ✭✭✭

Join Date: October 2005

Posts: 801

Is there any way to view all of the table/ views/etc that you've created in an Oracle db? If so, how?

Thanks
Ger...

0

Comments

Options
#2 23-11-2005 11:00am
seamus

Registered Users Posts: 68,317 ✭✭✭✭

Join Date: July 2001

Posts: 67070

"SHOW TABLES" works in MySQL...

0
Options
#3 23-11-2005 11:03am
gerTheGreat

Registered Users Posts: 871 ✭✭✭

Join Date: October 2005

Posts: 801

Nope "show tables"/ "show table", return

SP2-0158: unknown SHOW option "tables"
or
SP2-0158: unknown SHOW option "table"

(Thanks anyway;) )
any other ideas?

0
Options
#4 23-11-2005 11:05am
seedot

Closed Accounts Posts: 73 ✭✭

Join Date: June 2002

Posts: 68

SQL Server has a 'sysobjects' table that you can do a select on. I assume Oracle has something similar.

0
Options
#5 23-11-2005 11:07am
seamus

Registered Users Posts: 68,317 ✭✭✭✭

Join Date: July 2001

Posts: 67070

According to Google,
"SELECT * FROM ALL_TABLES;"

Should work.

0
Options
#6 23-11-2005 11:11am
gerTheGreat

Registered Users Posts: 871 ✭✭✭

Join Date: October 2005

Posts: 801

That got it:D

Cheers;)
ger...

0
Advertisement
Options
#7 23-11-2005 1:47pm
Karoma

Registered Users Posts: 19,396 ✭✭✭✭

Join Date: March 2002

Posts: 17630

..glad you found it.
SELECT whatever FROM CAT;
should do the trick (IIRC..which i most likely don't)

0
Options
#8 23-11-2005 2:17pm
Seth Brundle

Moderators, Politics Moderators Posts: 39,788 Mod ✭✭✭✭

Join Date: April 2003

Posts: 38762

SELECT * FROM USER_TABLES;
If you throw in a wher clause, remember that the names are in upper case!

0
Options
#9 23-11-2005 2:54pm
amen

Registered Users Posts: 2,781 ✭✭✭

Join Date: October 1999

Posts: 2598

for MSSQL don't be using sys tables use the information_schema views
MS don't guranatee that the sys tables will be the same between MS SQL version but the information_schema views should be

0