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

3 votes173 views1 answer
RENAME table pl sql
SQL
0 vote199 views1 answer
Replace divide by zero error with 0 in sql
SQL
4 votes171 views6 answers
Second max salary in sql
SQL
3 votes181 views2 answers
Sql asc
SQL
11 votes170 views2 answers
Oracle all source
SQL
4 votes181 views1 answer
Mysql ip address data type
SQL
4 votes199 views2 answers
Postgresql float data type
SQL
2 votes169 views1 answer
Mysql create user with mysql_native_password
SQL
3 votes164 views4 answers
Show sql server database
SQL
3 votes179 views2 answers
Mysql user permission database
SQL