Archive

Archive for April, 2007

BRANCH_TO_PAGE_ACCEPT

April 30, 2007 3 comments

There is a special REQUEST value you can use in ApEx which I remember seeing some time ago in the forum but have never found a particular use for… until today.

The REQUEST value is: BRANCH_TO_PAGE_ACCEPT. Setting this as the request value causes the page to skip rendering and move straight on to Page Processing (exactly as if the page you are calling had itself been submitted).

So, for example, clicking a link with a URL of: f?p=100:10:12345678:BRANCH_TO_PAGE_ACCEPT

Would be exactly the same as pressing a submit button with no REQUEST value on page 10.

You can, if you wish, also specify a REQUEST value by appending a | and the request value to the end of the URL. So:

f?p=100:10:12345678:BRANCH_TO_PAGE_PROCESSING|MY_REQUEST_VALUE

… is the same as clicking a button called MY_REQUEST_VALUE on page 10.

“Magic! – But what use is that?”

In my next blog entry I’ll write about using this to implement a search available on every page of an application.

Advertisements
Categories: ApEx

Using CONNECT BY to get a table of n rows

A handy way to get a table of n rows:

SQL> SELECT level FROM dual CONNECT BY level <= 10;

LEVEL
———-
1
2
3
4
5
6
7
8
9
10

10 rows selected.

Not strictly what CONNECT BY was intended for but a very useful trick nonetheless.

See Tom Kyte on CONNECT BY PRIOR, here:
http://www.oracle.com/technology/oramag/oracle/05-may/o35asktom.html

Categories: PL/SQL