Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    hyderabad
    Posts
    6

    Post Unanswered: sqlloader oracle constant

    How to load a constant value into a field while loading sqlloader.

    Ex. My table has a primary Key consists of 3 fileds,

    Text file has 2 fileds data, 3rd being a constant value 41, I want to load the data in the script.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sqlloader oracle constant

    I think you just have to put this in the control file:
    ...,
    field3 CONSTANT 41,
    ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •