oracle application 11i


    CTL File Logic

    Share
    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    CTL File Logic

    Post  shrikantgarud on Sun Jan 27, 2008 8:26 am

    LOAD DATA
    INFILE '/apps/visappl/cust/11.5.0/bin/SG_ITEM_DATA.dat'
    INTO TABLE SG_ITEM_STAGE
    APPEND
    FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
    (SEGMENT1,
    DESCRIPTION,
    TEMPLATE_NAME,
    MATERIAL_COST,
    PROCESS_FLAG CONSTANT 1,
    ENABLED_FLAG CONSTANT 'Y',
    TRANSACTION_TYPE CONSTANT 'Create',
    ORGANIZATION_CODE CONSTANT "V1")

      Current date/time is Sun Nov 19, 2017 6:55 pm