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 vote121 views1 answer
Casterar postgres
SQL
3 votes126 views1 answer
Postgres kill running query
SQL
0 vote116 views1 answer
Postgresql delete multiple rows
SQL
6 votes116 views2 answers
Insert into select mysql
SQL
0 vote125 views1 answer
Yesql
SQL
1 vote126 views2 answers
Mysql insert generate serie
SQL
1 vote115 views1 answer
Postgresql datetrunc too slow
SQL
1 vote118 views1 answer
Mysql how to reset primary key
SQL
6 votes124 views2 answers
How to copy data in sql
SQL
5 votes113 views1 answer
Oracle nls parameters
SQL