select constraint_name, constraint_type from user_constraints where table_name='&table_name';according to that you can delete the existing query... THanks
user640001 wrote:The question of "why" still hasn't really been answered.
I want to delete that record.
so, I need sql statement to find out that record.
Instead of the current
begin insert into table1 (<columns>) values (<values>); exception when dup_val_on_index then update table1 set <columns_values> where column_a = :variable_a and column_b = :variable_b end;
Which doesn't attempt to catch the unique constraint error.
insert into table1 (<columns>) values (<values>);