Hi all,
i am using oracle 11g.
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 update data from emp to emp1 table.
suppose emp table has duplicate data but i don't want to keep duplicate data on emp1 data.
my question is how can i validate data through a procedure or function. or anything else
can you please give an example how to i will do that.
below is my validation part. below validation should be for emp1 table
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
Thanks
Damby