CREATE INDEX PIPURINV_COMPSUPINVNO_IN ON oa_jk_purinv.pi_pur_invoice_hdr ( comp_code,sup_code,purinv_no)
/
ALTER TABLE oa_jk_purinv.pi_pur_invoice_hdr
ADD CONSTRAINT PIPURINV_COMPSUPINVNO_UK UNIQUE ( comp_code,sup_code,purinv_no) ENABLE NOVALIDATE
Subscribe to:
Post Comments (Atom)
-
What is Collection? A Collection is an ordered group of elements of particular data types. It can be a collection of simple data type or...
-
Q1) Display those who have joined in 81. Q2) Display those whose name start with A and job ends with K. Q3) Display those whose salary inclu...
-
PROCEDURE otb_setup_mat_sscatg(p_comp_code VARCHAR2,p_main_code varchar2,p_cat_code varchar2) -- u is cursor disp_period_cur is s...
No comments:
Post a Comment