Oracle get table 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

Similar codes

7 votes177 views1 answer
Grant schema permissions postgres
SQL
14 votes184 views1 answer
Oracle alter table add column not null
SQL
3 votes176 views1 answer
Laravel database Using Named Bindings
SQL
0 vote227 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
14 votes186 views4 answers
Online sql compiler
SQL
24 votes185 views4 answers
Mysql datetime
SQL
1 vote169 views1 answer
Drop table if exists oracle
SQL
5 votes180 views6 answers
In operator sql
SQL
0 vote172 views1 answer
Match end of string regex sql
SQL
1 vote191 views1 answer
Psql connect to another database
SQL