APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn




Apex Collections

Written by Richard Weug on Wednesday, 23 May 2012 09:19. Posted in PL/SQL

Where do you want to hard-code your information?  Somewhere pieces of data need to be written down for reference. They could be in a table; in some variables; within the query itself... there would be quite a few possibilities, regardless of the scenario.

Consider this statement:

select * from my_table where my_col IN ('CODE_1', 'CODE_2', 'CODE_3')

Apex and HTTPS

Written by Richard Weug on Monday, 21 May 2012 16:31. Posted in Installation

Adding HTTPS to Oracle Application Express on Oracle 10g Express

CentOS 5.x
Oracle 10g Express
APEX 3.x upgrade
Apache 2.x

If you are running APEX on Oracle 10g Express, you do not have access to the Wallet Manager per the OTN agreement.


Fun with dates

Written by Richard Weug on Wednesday, 16 May 2012 09:00. Posted in PL/SQL

Here I'm just listing some fun with dates, either from single row sql expressions or cool little queries.


APEX simple cookie example

Written by Richard Weug on Wednesday, 09 May 2012 09:18. Posted in Tips and Tricks

This is an example for the use of a simple cookie which gets created after submit when click on a button. Afterwars a region inside my page shouldn't be shown anymore. The cookie itself is valid for 30 days and will save the value "1".


Find in all ALL_VIEWS

Written by Richard Weug on Monday, 07 May 2012 10:22. Posted in PL/SQL

Quite some time ago when I first started blogging I wrote a post regarding limitations on searching the ALL_VIEWS dictionary view.

Simply put, if you would like to run a query such as this to find those views that contain the text "booking_no", you're not going to get very far