Oracle Database Data Dictionary Get list of all tables in Oracle
Example
select owner, table_name
from all_tables
ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. COLS is a synonym for USER_TAB_COLUMNS.
select *
from all_tab_columns
where table_name = :tname
