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

13 votes267 views2 answers
Oracle inner join
SQL
0 vote289 views1 answer
Group by two columns postgres
SQL
0 vote321 views1 answer
Snowflake drop column
SQL
1 vote276 views1 answer
PLS-00225 type
SQL
0 vote276 views1 answer
Postgresql import a database of gzip
SQL
0 vote263 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote291 views1 answer
Oracle truncate partition
SQL
1 vote262 views2 answers
Sql where keyword
SQL
17 votes297 views4 answers
Postgres list users
SQL
17 votes280 views2 answers
Mysql date to string
SQL