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 vote112 views1 answer
Nth max in my sql
SQL
0 vote140 views1 answer
Query to insert image
SQL
0 vote121 views1 answer
Sql find table by name
SQL
0 vote168 views1 answer
Oracle temporary table
SQL
0 vote116 views1 answer
Java sql timestamp now
SQL
1 vote121 views1 answer
Nullif postgresql
SQL
3 votes106 views2 answers
Oracle synonym
SQL
0 vote118 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
3 votes129 views2 answers
How to force truncate a table in mysql
SQL
1 vote116 views1 answer
Moodle query first user access
SQL