SQL> alter table mytable add (attachment_name varchar2(100), attachment_file blob, attachment_mime varchar2(200), attachment_charset varchar2(100));
- upload attachment in form
File Browse..
display as: inline drop zone ### recommend but optional
mime type column: ATTACHMENT_MIME ### case sensitive
filename column: ATTACHMENT_NAME ### case sensitive
character set column: ATTACHMENT_CHARSET ### case sensitive
- download attachment in report (classic/interactive)
Download BLOB..
*** any column but it must be numeric c and its pk can map to the blob (e.g. nvl2(attachment_file,id,null) as id)
primary key: ID
mime type column: ATTACHMENT_MIME
filename column: ATTACHMENT_NAME
character set column: ATTACHMENT_CHARSET
download text: #column_name# ### dynamic name like filename, the column can be set as hidden