Re: this is not trivial pursuit - My Aplogies

[John Ferguson <jferguson@INETNOW.NET>]

I apologize for being so short in my reply to Sam. After reading his E-mail
again, I see where I was mistaken. I was just having one of those days and
didn't think twice before I fired out my inappropriate reply.

I know its no excuse but I'm sure you can all relate. I will make sure to be
more careful in the future.

John

itzgee wrote:

> 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