SQL> 
SQL> create table temp_pk (col_1  varchar2(10), col_2  varchar2(10), col_3 date);

Table created.

SQL> 
SQL> create table temp_fk (r_col_1  varchar2(10), r_col_2  varchar2(10), col_3 number);

Table created.

SQL> 
SQL> alter table temp_pk add constraint temp_pk_pk primary key (col_1,col_2);

Table altered.

SQL> 
SQL> alter table temp_fk add constraint temp_fk_fk foreign key (r_col_1,r_col_2) references temp_pk(col_1,col_2) deferrable initially deferred;

Table altered.

SQL> 
SQL> SELECT fk.constraint_name
  2        ,fk.constraint_type
  3        ,fk.table_name
  4        ,fk.r_constraint_name
  5        ,pk.constraint_type
  6        ,pk.table_name
  7  FROM   user_constraints fk
  8        ,user_constraints pk
  9  WHERE  fk.constraint_name = 'TEMP_FK_FK'
 10  AND    fk.r_constraint_name = pk.constraint_name;

CONSTRAINT_NAME                C TABLE_NAME                     R_CONSTRAINT_NAME              C TABLE_NAME
------------------------------ - ------------------------------ ------------------------------ - ------------------------------
TEMP_FK_FK                     R TEMP_FK                        TEMP_PK_PK                     P TEMP_PK

SQL> 
SQL> SELECT substr(fk.column_name,1,30) fk_column_name
  2        ,substr(pk.column_name,1,30) pk_column_name
  3  from   user_cons_columns fk
  4        ,user_cons_columns pk
  5        ,user_constraints  con
  6  where  con.constraint_name = 'TEMP_FK_FK'
  7  and    fk.constraint_name = con.constraint_name
  8  and    pk.constraint_name = con.r_constraint_name
  9  and    fk.position = pk.position;

FK_COLUMN_NAME                 PK_COLUMN_NAME
------------------------------ ------------------------------
R_COL_1                        COL_1
R_COL_2                        COL_2