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

9 votes150 views4 answers
Add primary key to existing table sql
SQL
1 vote208 views3 answers
Date_add mysql
SQL
0 vote118 views1 answer
Mysql collation for all languages
SQL
1 vote177 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote165 views1 answer
How to use lower case in mysql
SQL
0 vote169 views1 answer
How to access to mysql without root
SQL
2 votes144 views1 answer
Sql update alias
SQL
3 votes150 views1 answer
Postgres kill running query
SQL
0 vote232 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote145 views1 answer
How to search query in python3 sqlite3
SQL