Re: list of all tables

In article <6ragog$3bq$1_at_nnrp1.dejanews.com>, twang_at_visa.com writes:

>I just start to use the SQL* PLUS. I got a question, how can I get a list of
>all tables. The describe command can diaplay the column of a table, but I
>first I have to know the table name. where and how can I get all the table
>names??

SELECT * FROM user_tables

gives a bunch of stuff you're probably not looking for, try

SELECT table_name FROM user_tables

if you're just looking for names.

Al LaPlante Received on Fri Aug 21 1998 - 06:00:14 CEST