Oracle get table schema

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 TABLE_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All database Tables

Similar codes

0 vote335 views1 answer
Alasql delete column
SQL
4 votes344 views3 answers
Rename table column postgresql
SQL
0 vote323 views1 answer
Where case insensitive like mysql
SQL
0 vote403 views1 answer
Sql doesn't contain
SQL
0 vote333 views1 answer
Sql server union if table exist
SQL
0 vote378 views1 answer
Fetching data from mysqldb
SQL
-1 vote408 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
5 votes343 views1 answer
Oracle sysdate - 1 month
SQL
0 vote316 views6 answers
Unique key in sql
SQL
0 vote318 views1 answer
Flask sqlalchemy decimal
SQL