Re: this is not trivial pursuit - give sam a break

[itzgee <itzgee@PRISMNET.COM>]

Uh ... I think Sam was poking fun at himself.  If you read carefully, you'll
notice that he was the original poster of the message.


Sam Spritzer wrote:

> Don't you just love it when clueless users make a request that, in their
world, makes perfect sense to them within the realm of their logic and
common
> sense.....hence, take a look at the following.
>
> I am trying to update a varchar(30) column from one table with a
varchar(30)
column from another table. I have already tested both columns for null
> values....and there aren't any. Can any of you shed any light in this?
>
>             *********************************************
> SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> Connected to:
> Oracle7 Server Release 7.3.4.3.0 - Production
> With the distributed, replication, parallel query and Spatial Data options
> PL/SQL Release 2.3.4.3.0 - Production
>
> SQL> update ps_employment a
>    2 set a.business_title = (select b.jobtitle
>    3 from ps_employees b
>    4 where a.emplid = b.emplid);
> from ps_employees b
>      *
> ERROR at line 3:
> ORA-01407: cannot update mandatory (NOT NULL) column to NULL
>             ****************************************
>
> SQRly yours,
> Sam