Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to list all tables and types
- Thread starter iuanee
- Start date
KenCunningham
Technical User
Not sure what's required but:
select table_name, owner
from dba_tables
will give you all tables and owners (assuming you have dba privileges when running it).
If by types you mean columns, desc <table_name> willl give you the columns in a table.
select table_name, owner
from dba_tables
will give you all tables and owners (assuming you have dba privileges when running it).
If by types you mean columns, desc <table_name> willl give you the columns in a table.
- Status
Similar threads
- Locked
- Question
- Locked
- Question