SELECT DISTINCT C.TABLE_NAME CHILD_TABLENAME,C.COLUMN_NAME
FROM (SELECT A.CONSTRAINT_NAME,
A.CONSTRAINT_TYPE,
A.TABLE_NAME,
B.COLUMN_NAME,
A.R_CONSTRAINT_NAME,
B.POSITION
FROM USER_CONSTRAINTS A, USER_CONS_COLUMNS B
WHERE B.CONSTRAINT_NAME = A.CONSTRAINT_NAME
AND A.CONSTRAINT_TYPE = 'R') C,
USER_CONS_COLUMNS D
WHERE D.CONSTRAINT_NAME = C.R_CONSTRAINT_NAME
AND D.TABLE_NAME = 'Member'
AND D.POSITION = C.POSITION;

SELECT DISTINCT C.TABLE_NAME CHILD_TABLENAME,C.COLUMN_NAME, c.data_type, c.data_length
FROM (SELECT A.CONSTRAINT_NAME,
A.CONSTRAINT_TYPE,
A.TABLE_NAME,
B.COLUMN_NAME,
A.R_CONSTRAINT_NAME,
B.POSITION,
c.data_type,
c.data_length
FROM USER_CONSTRAINTS A, USER_CONS_COLUMNS B, user_tab_columns c
WHERE B.CONSTRAINT_NAME = A.CONSTRAINT_NAME
AND A.CONSTRAINT_TYPE = 'R'
--and b.owner = c.owner
and b.table_name = c.table_name
and b.column_name = c.column_name) C,
USER_CONS_COLUMNS D
WHERE D.CONSTRAINT_NAME = C.R_CONSTRAINT_NAME
--AND D.TABLE_NAME = 'Member'
AND D.POSITION = C.POSITION;

SELECT DISTINCT C.table_name CHILD_TABLENAME,
                C.column_name,
                c.data_type,
                c.data_length
FROM   (SELECT A.constraint_name,
               A.constraint_type,
               A.table_name,
               B.column_name,
               A.r_constraint_name,
               B.position,
               c.data_type,
               c.data_length
        FROM   user_constraints A,
               user_cons_columns B,
               user_tab_columns c
        WHERE  B.constraint_name = A.constraint_name
               AND A.constraint_type = 'R'
               --and b.owner = c.owner
               AND b.table_name = c.table_name
               AND b.column_name = c.column_name) C,
       user_cons_columns D
WHERE  D.constraint_name = C.r_constraint_name
       --AND D.TABLE_NAME = 'Member'
       AND D.position = C.position; 

SQL> desc USER_TAB_COLUMNS
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 TABLE_NAME                       NOT NULL VARCHAR2(30)
 COLUMN_NAME                      NOT NULL VARCHAR2(30)
 DATA_TYPE                                 VARCHAR2(106)
 DATA_TYPE_MOD                             VARCHAR2(3 CHAR)
 DATA_TYPE_OWNER                           VARCHAR2(30)
 DATA_LENGTH                      NOT NULL NUMBER
 DATA_PRECISION                            NUMBER
 DATA_SCALE                                NUMBER
 NULLABLE                                  VARCHAR2(1 CHAR)
 COLUMN_ID                                 NUMBER
 DEFAULT_LENGTH                            NUMBER
 DATA_DEFAULT                              LONG
 NUM_DISTINCT                              NUMBER
 LOW_VALUE                                 RAW(32)
 HIGH_VALUE                                RAW(32)
 DENSITY                                   NUMBER
 NUM_NULLS                                 NUMBER
 NUM_BUCKETS                               NUMBER
 LAST_ANALYZED                             DATE
 SAMPLE_SIZE                               NUMBER
 CHARACTER_SET_NAME                        VARCHAR2(44 CHAR)
 CHAR_COL_DECL_LENGTH                      NUMBER
 GLOBAL_STATS                              VARCHAR2(3 CHAR)
 USER_STATS                                VARCHAR2(3 CHAR)
 AVG_COL_LEN                               NUMBER
 CHAR_LENGTH                               NUMBER
 CHAR_USED                                 VARCHAR2(1 CHAR)
 V80_FMT_IMAGE                             VARCHAR2(3 CHAR)
 DATA_UPGRADED                             VARCHAR2(3 CHAR)
 HISTOGRAM                                 VARCHAR2(15 CHAR)

AND D.TABLE_NAME = 'Member'

SQL> show user
USER is "SCOTT"
SQL> -- -------- create the tables
SQL> create table Case_Insensitive
  2     (fname varchar2(10)
  3     )
  4  ;

Table created.

SQL> create table "Case_Sensitive"
  2     (fname varchar2(10)
  3     )
  4  ;

Table created.

SQL> select table_name from user_tables;

TABLE_NAME
--------------------------------------------------------------------------------
Case_Sensitive
CASE_INSENSITIVE

2 rows selected.

SQL> select table_name
  2  from user_tables
  3  where table_name = 'case_sensitive';

no rows selected

SQL>
SQL> select table_name
  2  from user_tables
  3  where table_name = 'Case_Sensitive';

TABLE_NAME
--------------------------------------------------------------------------------
Case_Sensitive

1 row selected.

SQL>
SQL> select * from CaSe_InSeNsItIvE;

no rows selected

SQL> select * from case_sensitive;
select * from case_sensitive
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from "Case_Sensitive";

no rows selected

SQL> -- -------- clean up
SQL> drop table case_insensitive purge;

Table dropped.

SQL> drop table Case_Sensitive purge;
drop table Case_Sensitive purge
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> drop table "Case_Sensitive" purge;

Table dropped.