Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Get all table names in a database

Re: Get all table names in a database

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 14 Jan 2000 11:18:41 GMT
Message-ID: <387ea3ad.12965713@172.16.7.5> 





On Thu, 13 Jan 2000 20:36:59 -0500, "Legend" <legend_at_spacelab.net> wrote:



select owner,table_name from all_tables;




>Hello all,


>


>How would I get all the table names available in a database within sqlplus a


>session?


>


>regards,


>


>benny


>


>



Received on Fri Jan 14 2000 - 05:18:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US