Jul
18

List all Tables in Oracle Database

the imax Uncategorized 2009-07-18

I very rarely mess with Oracle at my workplace

Recently I forgot the name of a table so wanted to list all the tables in the oracle database

Obviously I didn’t know the command so I had to muddle with it for a while and then the following command did the trick and can be used to display all tables in oracle

<strong>select * from cat;</strong>

Related posts:

  1. How to check if someone deleted you from MSN Messenger There are many sites out there which provide the service...
  2. iPhone 4 vs Samsung Captivate A Side by Side comparison of  AT&T iPhone 4 and...

Address: http://www.wapopia.com/blog/2009/07/18/list-all-tables-in-oracle-database/
«
»
Trackback

3 comments untill now

  1. CB @ 2009-08-24 23:09

    thanks helped me with my oracle problems

  2. bola @ 2010-01-27 15:48

    Very helpful. Many Thanks!

  3. Deepak @ 2010-11-03 09:30

    it will work to see all the tables in oracle

    Select * from tab;

Add your comment now