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

2 votes120 views1 answer
Oracle to_char number format percentage
SQL
0 vote158 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote130 views2 answers
Null value in column violates not-null constraint
SQL
0 vote102 views1 answer
Output to file mysql
SQL
0 vote110 views1 answer
Mysql concat and use as where column
SQL
16 votes121 views4 answers
Ascending order mysql
SQL
2 votes158 views3 answers
Mysql kill
SQL
15 votes124 views2 answers
Select where duplicate mysql
SQL
1 vote115 views1 answer
Psql datetime grather than
SQL
0 vote115 views1 answer
Find invalid datetime field
SQL