Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Display Only Fields

Display Only fields are used just to display information in a simple format.  The following is an example of a Display Only field:

Like all items fields, the Display Only fields can be conditional for display.

  • Display as Text (does not save state):  The value of the page item will be displayed as text on the screen.  The value of the page item will not be saved to the session state when the page is submitted. 

  • Display as Text (does save state):  Same as Display as Text (does not save state) but the value is saved to the session state when the page is submitted.

  • Display as Text (escape special characters, does not save state):  The value of the page item will be displayed without any conversions.  Normally if the value contains HTML tags, the tags will be translated and rendered.  With this type of item, the tags will not be translated. 

  • Display as Text (based on LOV, does not save state):  This type of display field will be based on the results from a LOV.  Remember, each LOV has a display value and a result.  If the item is equal to the result, the display values will appear on the screen.  For example:  A LOV has the following display values and results:

STATIC:Red;R,Blue;B,Green:G,White;W

  • If the value of the page item is W from a SELECT statement, computation, process, etc., the display will be White.  The value of the page item will not be saved to the session state when the page is submitted.

  • Display as Text (based on LOV, does save state):  This is the same as the Display as Text (based on LOV, does not save state), but the value is saved to the session state when the page is submitted.

  • Display as Text (based on PLSQL, does not save state):  This is the more complicated type of the Display as Text fields.  This field is based on the results of an anonymous PL/SQL block.  When this field is rendered, the PL/SQL block will be evaluated and the result is displayed.  The PL/SQL block must set the page item to the value to be displayed.  The source of the item must be anonymous PL/SQL block. 


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  



Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

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

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.