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 vote372 views1 answer
Sql count value greater than
SQL
4 votes315 views1 answer
Create column mysql terminal
SQL
3 votes450 views1 answer
How to get yesterday date in sql
SQL
5 votes328 views1 answer
Postgresql functions
SQL
0 vote346 views1 answer
Sql delimiter to columns
SQL
-1 vote310 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote320 views4 answers
Change schema in sql server
SQL
34 votes345 views6 answers
Install mysql client ubuntu
SQL
0 vote328 views1 answer
How many rows affected in sqllite
SQL
0 vote345 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL