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

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


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Text Area Fields

Text Area fields are much like the Text fields described in the previous section.  The feature of the text area fields is that it can accept multiple lines of entry.  The field has automatic word wrap and scrolling built-in.  Text Area fields have no maximum amount that can be entered into the field.  An example of a text field might look like:

There are a few different types of Text Area Field definitions:

  • Text Area (auto height):  This type attempts to vary the size of the text area depending on the amount of data.  If the amount of data being shown is large, the area will be larger.  The reverse is true for a small amount of data.

  • Text Area with Counter:  This type of text area comes with a counter.  It will provide the user with a real-time counter of the number of character they have entered into the text area. 

  • Text Area with Spell Checker:  This text area integrates a Spell Checker with the text area.  For now, it is only configured for the English language.  An icon will be next to the text area.  The user can click that to spell check what is entered.  Figure 10.36 shows the spell checker results.

  • Text Area with Spell Checker and Counter:  The type combines the Spell Checker and the text counter. 

  • Text Area with HTML Editor:  This text area provides the user will some basic editing controls for the text.  The user can do formatting such as bold, italics, underline, fonts, size, colors and so forth.  The controls are simple but do help the user provide some formatting to the data.  The formatting will converted to the HTML equivalent tags:  Bold will convert to <strong>, italics to <em> and underline to <u>.  This must be taken into consideration because these new tags will take up space.

The attributes for the Text Area are all the same as a Text Field but the height will now have to be configured.  This will create the text area for the number of lines specified.

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


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.