1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to Insert Serial Number?

Discussion in 'Oracle Apps Technical' started by jagadekara, Nov 13, 2013.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,
    I need to insert Serial number into my Staging table.

    I have data file and control file,Through Sqlloader i am going to upload the data from data file to staging table.
    But in data file there is no serial number, but i need to insert in staging table.

    Any help?
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Also I need to insert null for two columns in staging table, but those columns not specified in data file. So how can I?
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi all,

    I done this requirement(I need to insert Serial number into my Staging table).

    I just created one sequence and in control file wrote like below.

    serial_number "sequence_name.nextval",
    remaining columns.
     
  4. siva551

    siva551 Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    hi,
    u try this
    l_column1 constanr"n"
    l_column2 constant"e"

    later u can updade the columns while validations