Which SQL command will display a list of tables in my Oracle database
Which SQL command will display a list of tables in my Oracle database
(OP)
I have an Oracle database, I am using SQL plus to browse my data. I need to know is an SQL command
that will display a list of tables in my database. Thanks!
that will display a list of tables in my database. Thanks!
RE: Which SQL command will display a list of tables in my Oracle database
from user_tables;
or if you just want to see that table names,
select table_name
from user_tables;
RE: Which SQL command will display a list of tables in my Oracle database
select * from all_tables;
You may refine that query by adding a where clause:
select * from all_tables
where owner = 'BBS'; <SUBSTITUTE YOUR USER ID FOR BBS>