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

0 vote149 views2 answers
Postgres isnull
SQL
-1 vote93 views1 answer
Mysql if example
SQL
2 votes112 views1 answer
Sql like variable
SQL
18 votes115 views2 answers
Sql inner join
SQL
1 vote120 views1 answer
Generate random data postgresql
SQL
3 votes119 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote122 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote111 views1 answer
Substr sql last character
SQL
2 votes118 views1 answer
How to select first row of database sql
SQL
22 votes143 views3 answers
Sql cheat sheet
SQL