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

0 vote218 views1 answer
Value of sold product using having and group by in sql
SQL
1 vote218 views1 answer
Last 6 months postgresql
SQL
0 vote227 views1 answer
Postgres sequence name
SQL
1 vote214 views1 answer
Oracle extract minute from date
SQL
4 votes217 views1 answer
Oracle select first 10 rows
SQL
1 vote211 views1 answer
Mariadb alter user host
SQL
-1 vote243 views2 answers
Sql truncate number
SQL
5 votes203 views1 answer
Mysql get last day of month
SQL
0 vote232 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote241 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL