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 vote110 views1 answer
Get substract count sql
SQL
0 vote116 views1 answer
Connect laravel to mysql on mac
SQL
0 vote109 views1 answer
Sql column contains special character
SQL
1 vote103 views1 answer
Crontab every month
SQL
2 votes123 views3 answers
Sql interview query questions
SQL
3 votes98 views2 answers
Mysql create database
SQL
0 vote106 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote111 views1 answer
Convert polygon to text in mysql
SQL
0 vote109 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote110 views1 answer
Two inner joins sql
SQL