Oracle all tables

Show all tables in oracle

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

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Oracle list 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

SELECT table_name FROM user_tables;

SELECT
  table_name, owner
FROM
  all_tables
ORDER BY
  owner, table_name

Source: chartio.com

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

1 vote204 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
7 votes197 views1 answer
Connect mysql docker
SQL
0 vote144 views1 answer
Sql truncate table referencing itself
SQL
1 vote180 views1 answer
Deleting database in sql
SQL
1 vote186 views1 answer
Mysql check if string contains comma separated
SQL
0 vote202 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote207 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote209 views1 answer
Django mssql backend
SQL
1 vote209 views1 answer
Denied
SQL
0 vote203 views1 answer
Spark sql grows beyond 64 kb
SQL