Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to list tables or views? (Beginner)
Zhang LinZai wrote:
>
> Please advise how to list tables or views in Oracle?
>
> --
> best regards,
> Zhang LinZai
>
> Email: fchn088_at_email.mot.com
SELECT * FROM USER_TABLES
[or]
SELECT * FROM TABS
[and]
SELECT * FROM USER_VIEWS
[and]
SELECT * FROM USER_INDEXES
Yours,
Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys
Received on Tue Nov 03 1998 - 01:29:07 CST