Re: How to list tables or views? (Beginner)

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Tue, 3 Nov 1998 09:19:47 -0000
Message-ID: <71mhrk$4rs$1@hagen.cloud9.co.uk>

To find all views:-
Select view_name from all_views;
To find your views :-
Select view_name from user_views;
To find all tables:-
Select table_name from all_tables;
To find your tables:-
Select table_name from user_tables;

Stewart Burnett

Please remove 'nospam' from address when replying direct.

Zhang LinZai wrote in message <363EABFB.5C89F388_at_email.mot.com>...
>Please advise how to list tables or views in Oracle?
>
>--
>best regards,
>Zhang LinZai
>
>Email: fchn088_at_email.mot.com
>
>
Received on Tue Nov 03 1998 - 03:19:47 CST