Show tables in schema oracle

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

Show tables in schema oracle

SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
--GET TABLE NAMES OF A SCHEMA IN ORACLE

Similar codes

1 vote196 views1 answer
Find logged in users mysql
SQL
0 vote249 views1 answer
How to print some string in mysql
SQL
0 vote221 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote214 views1 answer
Excel export from sql using python
SQL
0 vote269 views1 answer
TSQL Find csv file in folder
SQL
0 vote216 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
2 votes208 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote204 views1 answer
Database springboot
SQL
1 vote333 views1 answer
Concat first name and last name in mysql
SQL
0 vote233 views1 answer
Postgres copy command
SQL