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 vote356 views1 answer
Linebreak sql
SQL
0 vote394 views2 answers
List all constraints in postgres
SQL
7 votes324 views2 answers
Create index mysql
SQL
1 vote332 views2 answers
Sql where is not number
SQL
5 votes346 views1 answer
Oracle ORA-00054 origin
SQL
0 vote379 views1 answer
SQL Server date literal
SQL
2 votes327 views1 answer
Mysql list users on ubuntu
SQL
0 vote341 views1 answer
Conda install pymysql "windows"
SQL
0 vote327 views1 answer
Alter session set nls_language french
SQL
13 votes334 views4 answers
Mysql get last row
SQL