Oracle all tables in 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

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

0 vote269 views1 answer
Create bdd mysql
SQL
0 vote267 views1 answer
Sql server datetime to string
SQL
2 votes268 views1 answer
Grant revoke privileges to mysql username
SQL
1 vote272 views2 answers
Test sqlsrv connection
SQL
8 votes253 views1 answer
Alter tablespace add datafile
SQL
-1 vote278 views2 answers
Create temporary table sql
SQL
0 vote255 views1 answer
Docker export psql sql
SQL
0 vote267 views1 answer
Regex any word except sql
SQL
0 vote249 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote260 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL