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 vote231 views1 answer
How to find unique key in sql
SQL
2 votes226 views2 answers
Join update query in sql
SQL
6 votes245 views2 answers
Find mysql version linux
SQL
1 vote242 views3 answers
Getdate function in postgresql
SQL
0 vote237 views1 answer
Mysql grant access to one database
SQL
0 vote238 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote241 views1 answer
Php get closest location by latitude longitude
SQL
0 vote247 views1 answer
Mysql case when null
SQL
0 vote238 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote238 views1 answer
On sql table data exists
SQL