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 vote298 views1 answer
Postgres populate table from another table
SQL
0 vote291 views1 answer
Mysql multiple count
SQL
0 vote292 views1 answer
Select into table variable
SQL
4 votes272 views3 answers
Count with where
SQL
2 votes274 views1 answer
Date_format for time sql
SQL
3 votes317 views2 answers
Sql add year to date
SQL
0 vote281 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote230 views1 answer
Microsoft sql server management studio clear cache
SQL
6 votes278 views2 answers
Mysql first day of month
SQL
0 vote296 views1 answer
Mysql error 1452
SQL