Sequence in SQL-LOADER

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 28 Feb 2007 03:16:42 -0800
Message-ID: <1172661402.478962.256900@k78g2000cwa.googlegroups.com>

Greetings,

                I am using  sequence in sql-loader to insert unique

values in a table.

ctl file (Demo):

LOAD DATA
INFILE 'test.dat'
APPEND
INTO TABLE test_loader
FIELDS TERMINATED BY "|"
OPTIONALLY ENCLOSED BY '"'
(
name char,
loadseq SEQUENCE(MAX,5)
)

I want my value to start from 5 and thereafter get incremented by 1 every time.
But for now its getting incremented by 5?

Is any there any way in sql-loader or any other to achieve this?

DB Version:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production PL/SQL Release 9.2.0.6.0 - Production

Help would be appreciated.

TIA Received on Wed Feb 28 2007 - 05:16:42 CST