[ORACLE]Reque te sql

SELECT a1.owner, a1.constraint_name, a1.constraint_type,
       a1.table_name AS original_table, a1.r_owner, a1.r_constraint_name,
       a2.table_name AS ref_to_table
  FROM all_constraints a1, all_constraints a2
 WHERE a1.r_constraint_name = a2.constraint_name
   AND a1.constraint_type = 'R'
   AND a1.table_name = 'MA_TABLE';

SELECT atc.*, DECODE (c.constraint_type, 'R', 'y', 'n') AS is_fk
  FROM all_tab_columns atc, all_cons_columns cc, all_constraints c
 WHERE atc.owner = cc.owner
   AND atc.table_name = cc.table_name
   AND atc.column_name = cc.column_name
   AND cc.constraint_name = c.constraint_name

desc ma_table