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 vote159 views1 answer
Mysql select last 15 minutes
SQL
0 vote184 views1 answer
Oracle string length
SQL
0 vote162 views1 answer
Oracle index hint
SQL
1 vote164 views1 answer
Create procedure with encryption
SQL
0 vote176 views1 answer
Sql python hwo to pass a list in paramerter
SQL
1 vote192 views4 answers
How to check table in postgresql from terminal
SQL
1 vote121 views1 answer
Mysql collation
SQL
0 vote178 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
1 vote189 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes166 views2 answers
Sql add year to date
SQL