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 vote335 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote351 views3 answers
Showing all columns in an sqlite table
SQL
0 vote347 views2 answers
Advantages of stored procedures sql
SQL
0 vote337 views1 answer
Initcap in sql
SQL
2 votes342 views1 answer
Power query concatenate
SQL
0 vote356 views1 answer
Supprimer les valeur d'une table mysql
SQL
2 votes342 views1 answer
Laravel sql String
SQL
3 votes330 views1 answer
Oracle user quota on tablespace
SQL
0 vote359 views1 answer
Copying query result to excel
SQL
0 vote320 views1 answer
Concatenate columns in table
SQL