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 vote281 views1 answer
Ms sql print more than 1 variable
SQL
5 votes345 views3 answers
Oracle first day of last year
SQL
1 vote345 views1 answer
Grab all records from one table to another oracle sql
SQL
1 vote347 views1 answer
Continue in sql
SQL
0 vote332 views1 answer
Reset postgresql password windows
SQL
2 votes334 views2 answers
Change varchar length mysql
SQL
6 votes335 views5 answers
Alter table oracle
SQL
0 vote324 views1 answer
Mysql Error Code: 1005
SQL
0 vote349 views1 answer
Sqlite commands
SQL
0 vote331 views1 answer
Soql user profile
SQL