Oracle all tables in 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

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

1 vote106 views1 answer
Sql in array query
SQL
1 vote102 views1 answer
Mysql remove last empty newline
SQL
3 votes104 views1 answer
How to find names includes in sql
SQL
1 vote107 views1 answer
Mysql count multiple columns in one query
SQL
1 vote105 views1 answer
Access the postgres psql
SQL
0 vote64 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote98 views1 answer
Sql change date format
SQL
0 vote90 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
3 votes114 views1 answer
Mysql replace string in table
SQL
1 vote90 views1 answer
Autocommit mysql
SQL