Hello Database Experts,
I need your help to understand, would it be possible to have more than one BLOB column in a table ?
I have a requirement from the charitable organization to create an application in Oracle APEX, where they need to capture few documents (or doc images) of their visitors (visiting from abroad). They need to capture doc images like, Passport (Photo Page from passport), Visa Stamp Page (from passport) and Formal Invitation Letter.
How can I design a table for this?
Do I need to have separate FILE_TYPE, MIMETYPE, LAST_UPDATED for each of these BLOB column?
Your help and guidance would be greatly appreciated.
Thanks in advance.