Oracle SQL - Update
From: John W. Kreul, Hosp Info Svcs <jwkreul_at_vms.macc.wisc.edu>
Date: 15 SEP 94 08:41:08
Message-ID: <359jk8$nd_at_news.doit.wisc.edu>
(select
from ps_employee_update b where b.ssn = a.ssn); Received on Thu Sep 15 1994 - 08:41:08 CEST
Date: 15 SEP 94 08:41:08
Message-ID: <359jk8$nd_at_news.doit.wisc.edu>
Oracle SQL Question - Update Command
When I run the statement it returns the Oracle Error -
(a.street1,
*
ERROR at line 2:
ORA-01407: cannot update mandatory (NOT NULL) column to NULL
All the fields in both tables are set to NOT NULL and contain data.
I would appreciate any help on this manner.
Thank you.
update ps_personal_data a set
(a.street1,
a.street2, a.city, a.state, a.country, a.zip, a.work_phone, a.work_phone2, a.location, a.location_room, a.home_phone, a.email_part1, a.email_part2) =
(select
b.street1, b.street2, b.city, b.state, b.country, b.zip, b.work_phone, b.work_phone2, b.location, b.location_room, b.home_phone, b.email_part1, b.email_part2
from ps_employee_update b where b.ssn = a.ssn); Received on Thu Sep 15 1994 - 08:41:08 CEST