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 votes147 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote153 views1 answer
Enable Rabbitmq management plugin
SQL
8 votes199 views3 answers
Postgres database sizes
SQL
0 vote162 views1 answer
Reset keys in sql
SQL
0 vote155 views1 answer
Postgresql copy backup table
SQL
0 vote185 views2 answers
Clauses in mysql
SQL
0 vote149 views1 answer
Find most frequent value in SQL column
SQL
6 votes165 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote167 views1 answer
Alter constraint in sql
SQL
2 votes139 views2 answers
Compare date mysql
SQL