>Hi,
>
>Using SQL passthrough I need to return the primary key of an Oracle table. Against Microsoft SQL Server I can call the stored procedure or directly query the syscolumns and sysobjects tables.
>
>Are there equivalents in Oracle ?

SELECT
  UC.Constraint_Type,
  IC.Index_Name,
  IC.Table_Name,
  IC.Column_Name
FROM
   User_Constraints UC, User_Ind_Columns IC
WHERE IC.Index_Name = UC.Constraint_Name
   and UC.Constraint_Type = 'P'
ORDER BY IC.Table_Name