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

2 votes259 views1 answer
While loop sql
SQL
-2 votes275 views1 answer
No module named '_sqlite3
SQL
0 vote294 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote255 views1 answer
Sql combine results from two tables
SQL
0 vote267 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
-1 vote275 views1 answer
Mysql select count if contains
SQL
1 vote256 views1 answer
Oracle lock user
SQL
2 votes320 views1 answer
Remove foreign key constraints in postgres
SQL
4 votes265 views1 answer
What are the data types in sql
SQL
0 vote292 views1 answer
Oracle insert single quote in string
SQL