Re: Sequence Numbers

For sqlldr see the example below....

$ cat comp.ctl
LOAD DATA
replace
INTO TABLE component_groups
(
component_group_key "component_group_key_seq.nextval", component_group_id POSITION(001:007) integer external )

Cliff

BHAVESH GOSAR wrote:
>
> All,
>
> How do you use the same Sequence Numbering scheme from the
> application as well as the SQL*Loader...??
>
> We have a Sequence which is defined and the Sequence is generated
> from the application using <sequence_name>.NEXTVAL.
>
> We have data coming thru the Web-for...going thru an Interface
> table into the Application...How do we use the same
> <sequence_name>.NEXTVAL
> in the SQLLoader so that an Unique Seq. Number is generated
> irrespective of how the data is fed in the application...??
>
> Thanks,
> Bhavesh Gosar

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.