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!

Hi, I need help on type ORDdoc.

Discussion in 'SQL PL/SQL' started by ds priya, Feb 17, 2015.

  1. ds priya

    ds priya Guest

    I have a master table having a column of type ORDdoc . I need to create history table of the same structure and then insert the values from master table to history table.
    I am finding problem as inserting the value on type ORDdoc using the normal insert statement.
    Also, how to select this column to read the values.
    The values stored in this ORDdoc column is in below format
    (((255, 216, 255, 224, 0, 16, 74, 70, 73, 70, 0, 1, 1, 1, 0, 96, 0, 96, 0, 0, 255, 225, 0, 46, 69, 120, 105, 102, 0, 0, 77, 77, 0, 42, 0, 0, 0, 8, 0, 1, 1, 49, 0, 2, 0, 0, 0, 11, 0, 0, 0, 177, 170, 90, 172, 111, 61, 141, 140, 215, 49, 172, 128, 149, 44, 145, 150, 0, 128, 65, 198, 71, 168, 162, 154, 87, 3, 255, 217), , , , , ), JFIF, image/jpeg, 40562, ).

    Kindly help on this.
     
  2. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune