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 vote132 views2 answers
Plsql regex match whole word
SQL
1 vote138 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
2 votes141 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote166 views1 answer
Sql anywhere create procedure
SQL
5 votes147 views4 answers
Upload database mysql command line
SQL
0 vote135 views1 answer
Sql server order by nulls last
SQL
7 votes146 views3 answers
Sql set
SQL
0 vote150 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote130 views1 answer
Mysql command line ubuntu
SQL
2 votes151 views1 answer
Power query concatenate
SQL