given my requirements per employer, email validation will need to be done in the pl/sql layer.i'd like to implement RFC822/RFC1035 for email validation and was wondering if anyone had some code that does this? If by 'pl' you mean PERL, then you are mistaken - regular expressions and pattern matching are exactly what the language is meant for.The six types of integrity constraint are described briefly here and more fully in "Semantics": Oracle Database does not enforce view constraints.However, you can enforce constraints on views through constraints on base tables.
The following schema defines two tables "EMP" and "DEPT".
Itseems like I should be able to handle the ORA-1403 with an exception withoutspinning through the entire array (part of the whole idea of the array beingassociative), but I can't seem to find an example for this. (other than to put the data in a database table)TIA!
Oracle Database lets you create six types of constraints and lets you declare them in two ways.
You must define a composite unique key out of line.
create table Employee( 2 ID VARCHAR2(4 BYTE) NOT NULL, 3 First_Name VARCHAR2(20 BYTE), 4 Last_Name VARCHAR2(20 BYTE), 5 Start_Date DATE, 6 End_Date DATE, 7 Salary Number(8,2), 8 City VARCHAR2(20 BYTE), 9 Description VARCHAR2(80 BYTE) 10 ) 11 / Table created.