Home --> Workspace --> Application Builder --> Substitution Strings
I was asked a question the other day about substitution strings. Like many things, I did not know all of them off the top of my head. But I do know where to find them.
A trick I used to use was to create a page with an HTML Region and put all the substitution strings in there...just so I could remember them.
Recently I was developing an oracle database application and had the requirement to send out an email with an attachment. Initially it sounded pretty easy. I’ll just use the APEX_MAIL package and its all handled for me. But then I remembered, this was not an APEX application I was developing. So then I thought, no problem, I’ll just use the UTL_MAIL package. There is an API to add attachments. But wait, you can only add VARCHAR and RAW attachments and there is a max length of 32K on them.