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 vote288 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote282 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote321 views1 answer
Mysql backup query
SQL
1 vote281 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote293 views3 answers
SELECT * FROM
SQL
7 votes279 views4 answers
Database dump mysql command
SQL
0 vote286 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote329 views1 answer
Postgres - Login and connect as default user
SQL
0 vote285 views2 answers
Update all columns in one update
SQL
0 vote332 views1 answer
Postgres list all triggers
SQL