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

6 votes90 views2 answers
Spring data jpa application.properties mysql
SQL
17 votes133 views6 answers
Current date in sql
SQL
1 vote131 views1 answer
Oracle stop job
SQL
4 votes129 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote129 views1 answer
Wordpress database query change url
SQL
0 vote135 views1 answer
Oracle synonym procedure
SQL
3 votes138 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote150 views1 answer
Postgresql inline table
SQL
1 vote137 views2 answers
Sql left characters
SQL
2 votes174 views1 answer
Username sql
SQL