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
OS: RHEL
Scripting language: Bash and Python
Posts: 2,697
Thanks: 11
Thanked 243 Times in 183 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 Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote