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 vote379 views1 answer
Sqlite trim
SQL
3 votes331 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote340 views1 answer
We are intrested to work with your organization
SQL
1 vote355 views1 answer
Right outer vs left outer join
SQL
1 vote339 views1 answer
Declare variables sql
SQL
1 vote338 views1 answer
Limit offset order by mysql
SQL
26 votes290 views10 answers
Insert in to table sql
SQL
1 vote330 views1 answer
Crontab every month
SQL
0 vote358 views1 answer
Sintaxis SELECT sql
SQL
0 vote336 views2 answers
Sql server select where date
SQL