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

8 votes125 views1 answer
Oracle add months to sysdate
SQL
0 vote120 views1 answer
Inner joint
SQL
0 vote118 views1 answer
Sql comparison operators
SQL
8 votes128 views1 answer
Oracle current date plus 1 month
SQL
1 vote211 views1 answer
Oracle current sequence value
SQL
-1 vote135 views1 answer
MYSQL stored procedure select from
SQL
0 vote148 views1 answer
Mysql dump with table query
SQL
0 vote143 views1 answer
Set Mamp mysql globally
SQL
0 vote128 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote125 views1 answer
QUERY JPQL
SQL