Search notes:

DBMS_METADATA.GET_DEPENDENT_DDL

Get a table's foreign key as alter table statement. 
select
   dbms_metadata.get_dependent_ddl('REF_CONSTRAINT', 'TAB_C', 'ORG_DATA')
from
   dual;

See also

dbms_metdata.get_ddl, dbms_metadata.

Index