Oracle user tables

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 TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All Tables

Similar codes

2 votes211 views1 answer
How to make insert script from table in SQL server
SQL
1 vote204 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote209 views1 answer
Check if database exists sql
SQL
1 vote219 views1 answer
Db.Database.SqlQuery
SQL
1 vote270 views1 answer
How to show index type in postgresql
SQL
2 votes206 views1 answer
Wait delay in sql server
SQL
1 vote184 views1 answer
Set id count mysql
SQL
0 vote200 views2 answers
Connect to mysql server mac terminal
SQL
-1 vote230 views3 answers
Compute age mysql
SQL
0 vote204 views1 answer
Mysqldump ignore table
SQL