Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy




Oracle Tips by Burleson 

Create a Button Displayed Among This Regionís Items

Creating a button as Create a button displayed among this regionís items will result in both a button and a page item being created.  This means it can be positioned in the middle of other page items by using the Displayed region for the button attributes.  The button is then positioned in the region using Sequence, Begin on New Line, Begin on New Field, ColSpan and Display properties.

Notice in Figure 10.9, the buttons P2903_AMONG_ITEM_1 and P2903_AMONG_ITEM_1 are shown in the Buttons section and the Items section.  This is an indication the button is created among a regionís items.

Buttons created among the regionís items have some properties that are not available in a button created in a region position.

  • Display Location:  The position of the button among the other page items in the region is controlled by using the Displayed region on the Button Attributes page.  This means the button can be positioned anywhere within the other page items.

  • Button Request:  Since a button among region items is treated just like another page item, it can have its label set via an SQL statement, database column, etc.  When this is done, the value of the Label becomes the value of the REQUEST when the button is pressed.

In Figure 10.10, the button showing 19-JAN-06 had the label set with a SQL statement selecting SYSDATE.  This shows the button label can be set just like any other page item such as a text field.  The buttons are in positions in which other page items would normally appear.

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


Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracleģ is the registered trademark of Oracle Corporation. SQL Serverģ is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks