how to validate through a function or procedure ?
Posted on 2014-02-01
Hello expert ,
I have a two table emp and emp1 having columns company_id ,company_name,com_date which are having no constraints.
but i need to validate data when i will load data from one emp to emp1 table.
my question is how can i validate data through a procedure or function. or anything else
can you please suggest me and need code for that.
below is my validation part
Company Id is Mandatory and Unique
Company name is Mandatory
Date formats should be MM/DD/YYYY,
Valid Until date must be current or future date