Query to Get Primary and Foreing Key.

[luixleo]

Hello .I need query in Oracle to get Foreing key and Primary key

For Example
I have two tables

Category_Produc t
Id_Category PK
Description

Product
IdProduct PK
Id_Category FK
Description

I need to get this

Table ............... ...Column...... ........ TipyConstraint. ........Colum Ref Table _Ref

Category_produc t......... ..Id_Category ............... ..PK
Product........ ............... .. Id_Producto.... .......... PK
Product ............... ..........Id_Ca tegory ............... FK ...... Id_Category.... .. Category_Produc t