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 vote331 views1 answer
Data directory postgresql
SQL
-1 vote293 views1 answer
Export mysql table to file
SQL
0 vote429 views1 answer
Postgresql powershell query
SQL
1 vote309 views1 answer
Drush sql-dump
SQL
9 votes323 views1 answer
No sql
SQL
8 votes323 views2 answers
Oracle undo usage
SQL
0 vote300 views1 answer
Components/Fields of Internal Table
SQL
1 vote380 views2 answers
Copy table in sql
SQL
0 vote316 views1 answer
Group by max date
SQL
0 vote334 views1 answer
SQL-Arten
SQL