Q:
How to perform Unique check in PL/SQL
Oracle development, Oracle SQL, PL/SQL, Procedural Language/Structured Query Language, PL/SQL block, PL/SQL Unique Constraints Hi Experts,
I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before
inserting new record into Table XX
Table XX for combination of the following field list
(X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0
How can i do this check??
I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before
inserting new record into Table XX
Table XX for combination of the following field list
(X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0
How can i do this check??
ASKED:
Dec 10 2008 9:05 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
