To list all the tables in Oracle 11g / 12c
Method 1:
SELECT TABLE_NAME FROM ALL_TABLES;
Method 2:
if you have dba privileges use the following query
SELECT TABLE_NAME FROM DBA_TABLES;
To list all tables in schema
Step 1: Connect to the corresponding schema
Step 2: SELECT TABLE_NAME FROM USER_TABLES;
To list all the table in Oracle 11g / 12c with a particular column
Method 1:
SELECT TABLE_NAME FROM ALL_TAB_COLUMN WHERE UPPER(COLUMN_NAME)=UPPER('COLUMN_NAME');
Method 2:
if you have dba privileges use the following query
SELECT TABLE_NAME FROM DBA_TAB_COLUMN WHERE UPPER(COLUMN_NAME)=UPPER('COLUMN_NAME');
To list all tables in schema with a particular column
Step 1: Connect to the corresponding schema
Step 2: SELECT TABLE_NAME FROM USER_TAB_COLUMN WHERE UPPER(COLUMN_NAME)=UPPER('COLUMN_NAME');