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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help - really easy question

Re: Help - really easy question

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 14 Aug 1998 19:57:15 +0200
Message-ID: <6r1toh$gqe$1@newton.a2000.nl>


>How can I get a listing of tables?

    select owner, table_name
    from all_tables;

You might know that more table info can be found using

    desc all_tables

Check out the views (or is it a table?) DICTIONARY and DICT_COLUMNS to get a list of useful tables like all_tables.

Arjan. Received on Fri Aug 14 1998 - 12:57:15 CDT

Original text of this message

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