4 Replies Latest reply on Jun 23, 2013 3:30 AM by user10685034

    SQL insert script for BLOBs

    ade_adekoya
      Hello

      I have managed to upload my word and pdf documents into the database using blob support in APEX and having these columns in MY_DOC table

      ,FILENAME VARCHAR2(400) NOT NULL
      ,BLOB_CONTENT BLOB
      ,MIME_TYPE VARCHAR2(48)

      Now I would like to migrate the data to another environment using a SQL insert script, how do I cater for the BLOB column in the insert script?

      Kind Regards

      Ade