At first you should connect to the Database:
sqlplus username/password@database-name
To display all tables owned by the current user:
select tablespace_name, table_name from user_tables;To display all tables in a database:
select tablespace_name, table_name from dba_tables;To list all tables accessible to the current user, type:
select tablespace_name, table_name from all_tables;
Also You can find more info about views here:
all_tables
, user_tables
, and dba_tables
in Oracle Documentation.
0 коммент.:
Отправить комментарий