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)
-
Oracle Pipelined Table Functions Overview Basically, when you would like a PLSQL (or java or c) routine to be the «source» of data...
-
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...
-
In this chapter, we will discuss Exceptions in PL/SQL. An exception is an error condition during a program execution. PL/SQL supports prog...
No comments:
Post a Comment