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

3 votes273 views1 answer
Sql timestamp to date
SQL
0 vote281 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote299 views1 answer
Create table with primary key and foreign key in sql server
SQL
34 votes340 views6 answers
Alter table add foreign key mysql
SQL
0 vote282 views1 answer
Can't connect to postgresql mac os
SQL
2 votes285 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote300 views1 answer
List in one column mysql
SQL
0 vote280 views1 answer
List column names of multiple tables psql
SQL
0 vote292 views2 answers
Drop tables from local table database postgres
SQL
0 vote278 views1 answer
Import big data to mysql
SQL