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 vote221 views1 answer
Postgresql on conflict pair
SQL
34 votes235 views6 answers
Alter table add foreign key mysql
SQL
0 vote199 views2 answers
Postgresql get long running queries
SQL
0 vote184 views1 answer
Find all tables where column name exists oracle
SQL
0 vote170 views1 answer
Drop all tables in azure sql database
SQL
0 vote191 views1 answer
On sql table data exists
SQL
0 vote192 views1 answer
Postgresql copy backup table
SQL
0 vote189 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
5 votes218 views1 answer
Get column name sql server
SQL
0 vote223 views1 answer
Sql multiple into
SQL