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

7 votes178 views4 answers
How to reset the identity column in sql server
SQL
0 vote188 views1 answer
Sql server user permissions and roles
SQL
4 votes186 views1 answer
Psql get sequences
SQL
0 vote187 views1 answer
Sql server split string and insert into table select
SQL
0 vote179 views1 answer
Concatenate columns in table
SQL
19 votes188 views5 answers
Change column name mysql command line
SQL
0 vote186 views1 answer
How to check default value of column in sql server
SQL
3 votes196 views3 answers
Sql current year
SQL
0 vote235 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote185 views1 answer
Oracle show grants on table
SQL