Re: Q: 3rd party SQL*Loader alikes

From: SanDog <sandog_at_aol.com>
Date: 1997/06/22
Message-ID: <19970622002501.UAA00161_at_ladder01.news.aol.com>#1/1

In your SQL*Loader control file use the following:

...Pri_key POSITION(1:7) SEQUENCE (MAX,1)

Where Pri_key is the column name of the Oracle generated unique identifier. MAX tells Oracle to find the maximum value in Pri_key and the 1 sets the increment value, in this case MAX +1 for each row added.

Andy Received on Sun Jun 22 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Martin Bronstein: "Re: Forms 4.5 error!!"
Previous message: Alexey Solovjev: "Re: My Binary Experience"
In reply to: Rashid KArimov: "Q: 3rd party SQL*Loader alikes"
Next in thread: Martin Bronstein: "Re: Forms 4.5 error!!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message