Constraint Details

error: ====== unique constraints violated wildba.tr_lbuniq_tran_tool_docu ora-6512 wildba.ins_perd_trans_loan_ts line 1 constraints -------------unique: constraint name = tr_lbuniq_tran_tool_docu positioning ---------------------------------------ptl_tran_type 1 ptl_tool_srl_no 2 ptl_docu_no 3 ptl_seq_no 4

select ptl_srl_no,ptl_tran_type,ptl_tool_srl_no,ptl_docu_no, ptl_seq_no,ptl_docu_date,ptl_entr_dttm from perd_trans_loan_ts where ptl_docu_date = '13-dec-06' order by ptl_docu_no where ptl_docu_no='20062989' ptl_tran_type,ptl_tool_srl_no,ptl_docu_no,ptl_seq_no

select ptl_srl_no,ptl_tran_type,ptl_tool_srl_no,ptl_docu_no, ptl_seq_no,ptl_docu_date,ptl_entr_dttm from perd_trans_loan_ts where ptl_docu_no ='20063187' order by ptl_docu_no

select ptl_srl_no,ptl_tran_type,ptl_tool_srl_no,ptl_docu_no, ptl_seq_no,ptl_docu_date,ptl_entr_dttm from perd_trans_loan_ts where ptl_docu_no between '20060000' and '20069999' select ptl_srl_no,ptl_tran_type,ptl_tool_srl_no,ptl_docu_no, ptl_seq_no,ptl_docu_date,ptl_entr_dttm from perd_trans_loan_ts where trim(ltrim(ptl_docu_no)) > '20063197' select t1.ptl_docu_no from perd_trans_loan_ts t1 minus select t2.ptl_docu_no from perd_trans_loan_ts t2

select ptl_docu_no, count(ptl_docu_no) from perd_trans_loan_ts group by ptl_docu_no having (count(ptl_docu_no)>1) select ptl_docu_no,ptl_tran_type,ptl_tool_srl_no,ptl_seq_no,count(*) from perd_trans_loan_ts

group by ptl_docu_no,ptl_tran_type,ptl_tool_srl_no,ptl_seq_no having (count(*)>1) select count(*) from perd_trans_loan_ts group by ptl_docu_no,ptl_tran_type,ptl_tool_srl_no,ptl_seq_no having (count(*)=1) /