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

0 vote318 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote345 views1 answer
Connexion mysql
SQL
0 vote380 views2 answers
Disallowed function mysql to_date()
SQL
2 votes339 views1 answer
SQL column name Postgre
SQL
0 vote353 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote345 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote336 views1 answer
Mssql view column data type
SQL
19 votes345 views6 answers
Create table sqlite
SQL
1 vote327 views1 answer
How to truncate a table in databse
SQL
0 vote298 views2 answers
Influxdb delete measurement based on date
SQL