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 vote204 views1 answer
Mysql remove last empty newline
SQL
0 vote189 views3 answers
Group_concat sql server
SQL
1 vote183 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
4 votes203 views2 answers
Tables in sql
SQL
4 votes149 views2 answers
Select todays data postgres query
SQL
0 vote182 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote195 views1 answer
Unique index in mysql
SQL
6 votes184 views2 answers
Mysql execute file
SQL
0 vote189 views1 answer
How to query without duplicate rows in sql
SQL
10 votes179 views6 answers
Mysql delete duplicates
SQL