Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can loader insert nextval?

Can loader insert nextval?

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: 1998/05/08
Message-ID: <eFTutOAmk1U1Ewfo@rwx777.demon.co.uk>#1/1

Hi All,

RE: Oracle 7.3.3 and/or 8.0.4.

Can loader do the following?:

if col is null or blanks then

        insert my_seq.nextval
else

        insert original col value
endif

Thanks.
Steve
P.S
I don't want the loader built in sequences...

-- 
"The floggings will continue until morale improves."
Received on Fri May 08 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US