extracting all defined table list in sql

Page 1 of 1

1 Replies - 2157 Views - Last Post: 31 July 2012 - 07:39 PM

#1 08bce248  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 05-June 12

extracting all defined table list in sql

Posted 05 June 2012 - 08:25 PM

select *from Object_Type;
hi i used this code to get the table list . but when i run this code oracle express edition, it shows that table or view doesn't exist...any suggestions?????

nw i just find out the answer.....for oracle the code is...

SELECT * FROM all_objects WHERE object_type = 'TABLE';


thanks a lot....
Is This A Good Question/Topic? 0
  • +

Replies To: extracting all defined table list in sql

#2 idunno  Icon User is online

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 10-October 11

Re: extracting all defined table list in sql

Posted 31 July 2012 - 07:39 PM

you can also
 SELECT * FROM all_tables

Was This Post Helpful? 0
  • +
  • -
Page 1 of 1