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

0 vote228 views1 answer
Mysql order by where condition sub query
SQL
-1 vote206 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote171 views1 answer
List MySQL Table and Index Size
SQL
0 vote231 views1 answer
Cartesian product sql
SQL
2 votes184 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
5 votes206 views2 answers
Get columns number sql
SQL
0 vote235 views1 answer
Mysql subtract month from timestamp
SQL
0 vote236 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote186 views1 answer
Use between operator in mysql
SQL
17 votes247 views6 answers
Sql current date
SQL