Oracle user tables

SELECT * FROM USER_TABLES;		-- Tables from connected schema
SELECT * FROM ALL_TABLES;		-- Tables available to connected schema
	SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
	SELECT * FROM ALL_TABLES WHERE TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All Tables

Similar codes

6 votes170 views1 answer
How to get the size of the database in postgresql
SQL
4 votes160 views2 answers
Oracle unlock account
SQL
0 vote133 views1 answer
Select only one row sql
SQL
10 votes136 views2 answers
Oracle alter sequence nextval
SQL
0 vote159 views1 answer
How to get parent and child record in single query using sql
SQL
-1 vote129 views2 answers
On update cascade
SQL
0 vote133 views1 answer
Drop constraint in ms sql
SQL
1 vote211 views1 answer
How to select the nth row in a SQL database table?
SQL
5 votes141 views3 answers
Mysql remove unique constraint
SQL
7 votes166 views3 answers
Restore postgres database from sql file
SQL