chalie001
asked on
constraint check
hi is it possible to add a constraint where emp_id <> new_emp_id
alter table emplpyee add constraint tesxxx (emp_id <> new_emp);
in table i will have
emp_id new_emp_id
xxx11 222333
the constraint must prevent this
emp_id new_emp_id
xxx11 xxx11
am in 11g database
alter table emplpyee add constraint tesxxx (emp_id <> new_emp);
in table i will have
emp_id new_emp_id
xxx11 222333
the constraint must prevent this
emp_id new_emp_id
xxx11 xxx11
am in 11g database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER