/SQL/How to get all the tables displayed in oracle

How to get all the tables displayed in oracle

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

Source: grepper.com

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Source: grepper.com

Similar codes

2 votes200 views1 answer
Oracle generated column
SQL
0 vote211 views1 answer
Initcap in mysql
SQL
0 vote255 views1 answer
Sqlite3 pragma foreign keys
SQL
4 votes214 views1 answer
Adding data to table in sql python
SQL
0 vote201 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote190 views1 answer
Sequelize postgresql schema
SQL
13 votes257 views6 answers
Mysql remove duplicates
SQL
0 vote232 views1 answer
Product of a column in mysql
SQL
1 vote299 views1 answer
Mysql is odd
SQL
10 votes217 views2 answers
Rtrim sql
SQL