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

10 votes207 views1 answer
Oracle dependencies table
SQL
2 votes188 views2 answers
Select multiple tables mysql
SQL
0 vote239 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote241 views1 answer
Sqlalchemy _in array sqlite
SQL
14 votes223 views3 answers
Oracle sql limit results
SQL
0 vote212 views2 answers
Identity column in sql server
SQL
0 vote219 views1 answer
Radius search with point data in mysql
SQL
0 vote205 views1 answer
Show size of all tables postgres
SQL
4 votes216 views4 answers
Start mysql
SQL
0 vote213 views1 answer
Placements hackerrank solution
SQL