Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help - really easy question
>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
![]() |
![]() |