Removing/finding HTML-code using regular expressions:
SELECT regexp_replace(name, ‘<.*?>’) name_without_tags FROM table WHERE regexp_like(name, ‘<.*?>’)
Categories: Apex
upload/download
Download from database
htp.init; — The mime header indicates what the type of the file is (browser will react on that) owa_util.mime_header(r_bfe.filetype, false); — use Content-Disposition: attachment to open a dialog box or inline to open in place Read more…