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 vote331 views1 answer
Where database run
SQL
2 votes313 views2 answers
Postgres select duplicate columns
SQL
54 votes513 views6 answers
Sql rename column
SQL
1 vote308 views1 answer
Sql server 2016 reseed identity
SQL
10 votes318 views1 answer
Oracle object dependencies
SQL
11 votes374 views2 answers
Import mysql dump command line windows
SQL
18 votes334 views3 answers
Get the list of all tables in sql server
SQL
-1 vote337 views1 answer
Window functions in sql
SQL
0 vote314 views1 answer
Sql case when exists in another table
SQL
1 vote277 views2 answers
Delete auto increment mysql
SQL