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

13 votes152 views3 answers
List all the tables in sql
SQL
0 vote127 views1 answer
Select count concat string sql server
SQL
4 votes123 views3 answers
Sqlite show columns
SQL
0 vote117 views1 answer
Sql count matching group by
SQL
1 vote125 views1 answer
Sql how to duplicate a table
SQL
7 votes118 views1 answer
Minecraft forge server host
SQL
0 vote142 views1 answer
Mysql concatenate select results
SQL
0 vote127 views1 answer
How to update sql server version
SQL
0 vote127 views1 answer
Increase speed of like queries postgres
SQL
-1 vote115 views2 answers
Sql convert date to string yyyy-mm-dd
SQL