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

Home -> Community -> Usenet -> c.d.o.server -> Can I use my own sequence with SQLLDR?

Can I use my own sequence with SQLLDR?

From: <jkc_at_consultant.com>
Date: Thu, 10 Feb 2000 02:52:15 GMT
Message-ID: <87t94u$f03$1@nnrp1.deja.com>


Does anyone know if I could use my own sequence when loading via sqlldr?

something like:

LOAD DATA
 INFILE 'load_test.dat'
 INTO TABLE test1
 fields terminated by ","
 (candidate_id MYSEQ.NEXTVAL,
 name )

-John

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 09 2000 - 20:52:15 CST

Original text of this message

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