Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)
A BLOB data type stores unstructured binary large objects. A table column with a BLOB data type can be used to store all types of files such a documents, spreadsheets, images and plain text. You can manage BLOB columns by easily adding file upload and download functionality to a form you create using Oracle Application Express (APEX).
APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).
The following is a screencast to demonstrate:
- how to create a simple APEX application to store the content of any file into a BLOB column and
- how to save the content of that BLOB into a file on the database server.
I recorded the screencast on Windows 7 and Oracle APEX 4.0 that comes pre-installed with Oracle Database Express Edition 11g Release 2.
But first, here is the code that I used in the screencast:
Comments Off | Filed in Oracle | Tags: apex, howto, video
