/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

1 vote91 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote106 views1 answer
Concatenate columns in table
SQL
0 vote111 views1 answer
Set column in all row mysql
SQL
-1 vote104 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
1 vote109 views1 answer
How to get the date diff on once field in sql server
SQL
7 votes172 views1 answer
Oracle alter sequence restart start with
SQL
0 vote123 views1 answer
Update sqlite
SQL
1 vote104 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote124 views1 answer
Disable database droping sql
SQL
2 votes116 views5 answers
SQL trigger
SQL