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 vote265 views1 answer
IIF
SQL
3 votes273 views2 answers
Current year sql
SQL
33 votes311 views6 answers
Sql delete
SQL
1 vote276 views1 answer
How to delete a record from sqlite in android
SQL
0 vote278 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
1 vote272 views1 answer
How do you use sql in you company
SQL
0 vote288 views3 answers
CONTACT FORM SQL
SQL
0 vote283 views1 answer
Oracle for loop on list
SQL
1 vote276 views4 answers
Sql now
SQL
0 vote297 views1 answer
Reset postgres table index to next max value
SQL