For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

   
  Oracle Tips by Burleson

Page Item

Create a page item to hold a string value indicating the function that has been initiated.  For the demo, a page item named P100_SEARCH has been created.

Button and Branch

A button named FIND_PERSON has been created.  Then, a branch was created to navigate to the global application page to search for a person.  The Action for the branch is shown in Figure 16.5.  The conditional processing for the branch is set to execute when the FIND_PERSON button is pressed as shown in Figure 16.6.  This shows navigation to APP 500: PAGE 200.  This is the application id and page id of the reusable page.  The P200_FROM_APP_ID and P200_FROM_PAGE page items are being set so the reusable page knows where to navigate back to when a person’s name is selected. 

Computation

The computations job is to set a page item to indicate that a Find Person function has been initiated.  This value will be used by the processes when the page returns from doing the search.  This is done by creating an After Submit computation for the P100_SEARCH page item.  The page item will be set to a value of Find Person.  Figure 16.7 shows the Source and Conditions for the computation.


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm  



For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: