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

1 vote233 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote231 views1 answer
Sql select where more than one record exists
SQL
3 votes223 views4 answers
Stop MySQL
SQL
0 vote215 views1 answer
Regex mongoose
SQL
7 votes218 views2 answers
Create index mysql cli
SQL
1 vote217 views2 answers
Mysql: command not found
SQL
6 votes216 views5 answers
Mysql get last insert id
SQL
1 vote229 views2 answers
Check if word is in column sql
SQL
0 vote238 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
3 votes353 views6 answers
Sql unique select
SQL