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

0 vote193 views2 answers
Database owner can't create new tables postgres
SQL
0 vote196 views1 answer
SAP Return
SQL
1 vote187 views5 answers
Spring boot sql logging
SQL
3 votes198 views1 answer
Null sql
SQL
1 vote229 views1 answer
Select from describe sql
SQL
0 vote201 views1 answer
Generate sequence number in sql server
SQL
0 vote185 views2 answers
Mysql create table if not exists
SQL
1 vote197 views1 answer
Oracle sql average
SQL
0 vote192 views1 answer
Update top 100 sql
SQL
-1 vote195 views1 answer
How to switch user in mysql
SQL