Hello,
I have Oracle XE 11.2.0 loaded on a Windows server. It works fine. I use Apex 4.1 on that sever as well.
In a table I have a column (LIST_FILE) which contains the name of a file, and does not include the file's extension. I recently added a BLOB column (LIST_PDF) to that table.
I'd like to create SQL to update each row in that table by inserting the PDF file into the blob. For each row in the table, there exists a file starting with the value in LIST_FILE and appended with a period and PDF (.PDF). File1.PDF, File2,PDF, etc. The windows directory containing the PDF's can be moved anywhere on the windows server.
How do I construct the SQL to update the BLOB column?
Thanks for your help.