Re: SQLPLUS QUESTION

In article evo_at_news2.cts.com, lan <lan_at_bluebird.com> writes:
>
> Hi all,
>
> What command should I use to list database name and table names
> in SQLPLUS?
>
> thanks.
>
> --Lan
>
>

Have you looked in to the views that Oracle provides? Try

	set pause on
	select view_name from all_views;

to see them.

one interesting one would be

        select table_name from user_tables;

another would be

        select * from v$database;

You can use describe on these view ie

        describe user_tables

to see them, try also

        describe user_tab_columns         

These views are a part of oracle, not sql*plus, so you can do nice things like using user_tab_columns to populate a pick list in Oracle reports etc.

All the best,

Regards

Tim Received on Tue Mar 19 1996 - 00:00:00 CET