Thread: How to List my tables in Oracle database

View Single Post
  #2 (permalink)  
Old 12-19-2006, 02:03 AM
nixcraft's Avatar
nixcraft nixcraft is offline
Never say die
User
  
Join Date: Jan 2005
Location: BIOS
Posts: 1,521
Thanks: 2
Thanked 16 Times in 13 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default
To list all your tables in Oracle server, use the following command:
Code:
SELECT * FROM cat;
First connect to server using Oracle sql plus client:
Code:
sqlplus scott/tiger
Now type at sql> prompt:
Code:
SELECT * FROM cat;
Also don't forget to set the column widths
Code:
COL table_name FORMAT a30;
COL table_type FORMAT a30;
Now to get list of tables in oracle:
Code:
SELECT * FROM cat;
__________________
Vivek | My personal blog
Linux Evangelist
+ ADD [SOLVED] thread prefix to your thread when your problem is sorted out by editing your thread.
+ Always use CODE tags for posting system output and commands!
Reply With Quote