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 vote290 views1 answer
Influxdb export to csv
SQL
0 vote275 views1 answer
Find and replace database table phpmyadmin
SQL
7 votes268 views4 answers
Mysql delete older duplicates
SQL
2 votes264 views1 answer
Query to find table size in oracle 12c
SQL
0 vote258 views1 answer
Get created time of database psql 8
SQL
0 vote291 views1 answer
Mssql dockere
SQL
21 votes269 views3 answers
Sql average
SQL
0 vote360 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
1 vote270 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote281 views2 answers
Suse stop MySQL
SQL