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

12 votes138 views6 answers
Select distinct
SQL
1 vote149 views1 answer
OSError: mysql_config not found
SQL
1 vote151 views1 answer
How do you use sql in you company
SQL
6 votes132 views3 answers
Mysql first day of year
SQL
5 votes179 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
8 votes201 views1 answer
Oracle search code in packages
SQL
0 vote130 views1 answer
Cast as decimal postgresql
SQL
0 vote129 views1 answer
Sql server convert date to weekday
SQL
0 vote118 views1 answer
Mysql percentage of total
SQL
0 vote131 views1 answer
Delete record by id sql
SQL