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 vote95 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote110 views1 answer
Convert polygon to text in mysql
SQL
0 vote143 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote97 views2 answers
How to set global time_zone in mysql
SQL
1 vote147 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote103 views1 answer
Postgresql pass array in function
SQL
0 vote110 views1 answer
Sql server list table sizes
SQL
0 vote95 views1 answer
Python mysql query where
SQL
0 vote100 views1 answer
Sql count more than 1
SQL
1 vote142 views1 answer
Postgresql where datetrunc month and year equal
SQL