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

2 votes148 views1 answer
Sql create database
SQL
0 vote155 views1 answer
Get all employees if name ends with in sql
SQL
0 vote173 views1 answer
T-SQL Create Trigger
SQL
34 votes168 views6 answers
Sql change data type
SQL
5 votes199 views1 answer
Oracle sysdate - 1 month
SQL
1 vote151 views1 answer
Oracle select first result
SQL
0 vote163 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote180 views1 answer
Mysql preg replace
SQL
0 vote152 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
1 vote180 views2 answers
Mysql does sentance contain word
SQL