160: function get_id_col ( p_table_name in varchar2 , p_schema in varchar2 ) return varchar2 is
161: cursor get_pk_col_name is
162: select ind.column_name
163: from all_ind_columns ind, 164: all_constraints cons 165: where cons.owner = p_schema
166: and cons.table_name = p_table_name
167: and cons.constraint_type = 'P'
168: and cons.constraint_name = ind.index_name
[Home] [Help]