Archive for mei, 2012

Interesting Analytical Functions

I had to write some reports for a personal application of mine last night and needed to expand beyond my usual set of analytic functions that I normally use. I thought it would be a good idea to do a

Read More

Flashback

The Flashback Query feature of Oracle (10g) can be really helpful when you run that UPDATE or DELETE statement and then, after the COMMIT, you discover that you made a mistake! Wouldn't it be nice to be able to look

Read More

Using a comma-separated list in an SQL query

Dit artikel gaat over het gebruik van de IN Operator,..

Read More

Apex Collections

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

Read More

Utilizing Secure Sockets Layer (SSL)

Secure Sockets Layer (SSL) is a protocol for managing the security of data transmitted on the Internet. For Web applications, SSL is implemented by using the HTTPS protocol. Oracle recommends that you run Oracle Application Express applications using SSL (HTTPS

Read More

Apex and HTTPS

Adding HTTPS to Oracle Application Express on Oracle 10g Express CentOS 5.x Oracle 10g Express APEX 3.x upgrade Apache 2.x mod_ssl open_ssl If you are running APEX on Oracle 10g Express, you do not have access to the Wallet Manager

Read More

Fun with dates

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

Read More

APEX simple cookie example

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

Read More

Find in all ALL_VIEWS

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

Read More

Create a custom download link

The default method of downloading an Interactive Report is clicking on the Action button, then the Download button and then selecting the desired format. For the CSV report download format:

Read More