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

1 vote172 views1 answer
Error code 1292 mysql workbench
SQL
0 vote385 views1 answer
Power bi connect to postgresql
SQL
6 votes176 views2 answers
Sql display max value
SQL
0 vote153 views1 answer
Opensuse stop MySQL
SQL
2 votes179 views2 answers
Mysql alter column default
SQL
9 votes156 views3 answers
Show table columns mysql command line
SQL
0 vote186 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote177 views1 answer
Querry mysql by 2 columns
SQL
0 vote185 views2 answers
Enter into postgresql database,create user and grant Access
SQL
1 vote175 views1 answer
Name of today sql
SQL