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

32 votes116 views6 answers
Insert select
SQL
1 vote67 views1 answer
Insert into sql
SQL
0 vote111 views1 answer
Create bdd mysql
SQL
0 vote143 views1 answer
Gcloud sql instance list
SQL
0 vote113 views1 answer
Why we have to set the password for my sql server
SQL
1 vote126 views2 answers
Mysql between
SQL
0 vote127 views1 answer
Shell script to log mysql cpu usage
SQL
1 vote115 views1 answer
Get last week data in mysql
SQL
0 vote122 views1 answer
Primary key multiple colums
SQL
3 votes112 views2 answers
Oracle grants
SQL