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!

Oracle Control File

Discussion in 'Other Development Tools' started by ssraman, Jan 15, 2013.

  1. ssraman

    ssraman Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,


    My Table structure

    column1 varchar(10)
    column2 Date
    Column3 varcahr(2)
    Column4 varcahr(2)

    By Data file

    asds 12/12/2001asas
    textsd asds
    asds 12/12/2001asas
    ramkiy asds


    I still want to insert row 2 and row 4 into table by defaulting the date. Can someone give me how can I handle this in control file?
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Have you thought about an trigger on the table, (after insert??) to default the column value to the sysdate if the inserted value is null? Then remove the trigger when you're done w/ it.

    Just another option to think about...

    CJ
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Raman,

    what type of data file you are dealing with ?? csv or dat or txt ???