A.1 Available Item Types

Table A-1, "Available Item Types" describes available item types in Application Builder and notes important attributes that control item behavior.

Table A-1 Available Item Types

Item Type	Description
Check Box	Displayed using a list of values. A list of values is required for items displayed as check boxes. The value corresponding to a checked box is returned in a single colon-delimited string. The following example demonstrates how to create a single check box that returns `YES`. This example would display both a check box and a field label. SELECT NULL display_text, 'YES' return_value FROM DUAL; This example includes the additional text Click to select. SELECT 'Click to select' display_text, 'YES' return_value FROM DUAL; See Also: "APEX_UTIL" in Oracle Application Express API Reference for information about breaking up returned values Page Designer item attributes: Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Number Columns - Enter the number of layout columns used to display the check boxes. For example, a value of 2 would display two columns of check boxes. By default, all values display in one column. See Also: "Creating a Cascading List of Values" Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Number of Columns - Enter the number of layout columns used to display the check boxes. For example, a value of 2 would display two columns of check boxes. By default, all values display in one column. See Also: "Creating a Cascading List of Values"
Color Picker	Renders as a text field with an icon. When the user clicks the icon, a popup window appears. When the user makes a selection from the palette, the HTML value for the color selected (for example, #000000 for black) is returned. Note: When creating a new item of this type, first select Popup List of Values and then Color Picker. Page Designer item attributes: Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details.
Date Picker	Displays a text field with a Calendar icon next to it. When clicked, this icon displays a small calendar where the user can select a date and a time (optional). Page Designer item attributes: Settings, Minimum Date - Enter the minimum date that can be input or selected. Settings, Maximum Date - Enter the maximum date that can be input or selected. Settings, Show - Select when the date picker pop-up calendar displays. Settings, Show other Months - Specify whether the leading dates from the previous month and the trailing dates for the next month display. The leading and trailing dates fully populate the first and last lines of the calendar. Settings, Navigation List for- Select whether select lists are provided within the calendar pop-up for the month and/or year. Settings, Highlighted Date - Enter a default date value to be highlighted when the calendar pop-up displays. See Help for more details. Appearance, Format Mask - Enter a date format mask to apply to this component. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Settings, Format Mask - Identify the date format mask used by the item type. You can use substitution syntax to reference a dynamic format mask from an application or page item. Settings, Highlighted Date - Enter a default date value to be highlighted when the calendar pop-up is invoked. If not specified, the calendar highlights the current date and time. See Help for more details. Settings, Minimum Date - Enter the minimum date that can be input or selected. Settings, Maximum Date - Enter the maximum date that can be input or selected. Settings, Show - Select when the date picker pop-up calendar displays. Settings, Show other Months - Specify whether the leading dates from the previous month and the trailing dates for the next month display. The leading and trailing dates fully populate the first and last lines of the calendar. Settings, Navigation List - Select whether select lists are provided within the calendar pop-up for the month and/or year.
Date Picker (Classic)	Displays a text field with a Calendar icon next to it. When clicked, this icon displays a small calendar where the user can select a date and a time (optional). If the format you need is not included in the Display As list, select Date Picker (use application format mask) or Date Picker (use item format mask). The latter uses the value from the Format Mask field in the Source section of the Edit Page Item page.
Display Image	Enables the display of images stored in an image URL stored in another page item or in `a BLOB` column. To alter where the image is stored, edit the item and configure the Based on attribute. Options include: Page Designer and Component View item attributes: Settings, Based On - Determines where the item is retrieved from. To learn more about an attribute, see field-level Help. Settings, Alternative Text Column - Enter the uppercase page or application item name which holds the alternative text for this image. This text is read by screen readers when an end user navigates to this item. Settings, Filename Column - Enter the uppercase page or application item name that holds the filename column value associated with the BLOB column. Settings, BLOB Last Updated Column - If specified, the column is used for browser caching. It identifies if the image changed since the last browser request. If not entered, no caching is done. Note: This attribute is case sensitive and the column must be of type `DATE`.
Display Only	Displays the item as display only text. Page Designer and Component View item attributes: Settings, Save Session State - Stores the current value in session state when the page gets submitted. Settings, Based On - Specifies what gets displayed in the field. Options include: Page Item Value - The current value of the page item displays. Display Value of List of Values - The current value of the page item maps to a different display value using a list of values. Output of PL/SQL Code - The specified PL/SQL code takes care of emitting the necessary output for the page item. Settings, Show Line Breaks - Select Yes to convert line breaks in the display value to an HTML line break and display them in HTML output.
File Browse	Displays a text field with a Browse button. The Browse button enables the user to locate and upload a file from a local file system. See Also: "About Securing File Uploads" Page Designer attributes: Settings, Storage Type - Identify where the uploaded file is stored. Settings, MIME Type Column - Specify the name of the column where the `MIME` type of the uploaded file should be stored. Settings, Filename Column - Specify the name of the column where the file name of the uploaded file should be stored. Settings, Character Set Column - Specify the name of the column where the character set of the uploaded file should be stored. Settings, BLOB Last Updated Column - Specify the name of the column to update with the current time stamp when a file is uploaded. Settings, Display Download Link - Select Yes to display the download link next to the Browse button. Settings, Download Link Text - Text used for the download link. Settings, Content Disposition - Determines if the downloaded content is displayed inline within the Browser window or if a Open dialog displays. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Component View attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Settings, Storage Type - Identify where the uploaded file is stored. Settings, MIME Type Column - Specify the name of the column where the `MIME` type of the uploaded file should be stored. Settings, Filename Column - Specify the name of the column where the file name of the uploaded file should be stored. Settings, Character Set Column - Specify the name of the column where the character set of the uploaded file should be stored. Settings, BLOB Last Updated Column - Specify the name of the column to update with the current time stamp when a file is uploaded. Settings, Display Download Link - Select Yes to display the download link next to the Browse button. Settings, Download Link Text - Text used for the download link. Settings, Content Disposition - Determines if the downloaded content is displayed inline within the Browser window or if a Open dialog displays.
Hidden	Creates a hidden page item. Page Designer and Component View attribute: Settings, Value is Protected - Select Yes to prevent hidden values from being manipulated when a page is posted.
List Manager	Based on a list of values. This item enables you to manage a list of items by selecting and adding to a list. The list of values display as a popup. Page Designer attributes: Settings, Fetch - Select how data is displayed when the Popup LOV is opened. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Also: "Creating a Cascading List of Values" Component View attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Settings, Fetch - Select how data is displayed when the Popup LOV is opened. See Also: "Creating a Cascading List of Values"
Number Field	Displays a number field. You can configure number range checks for values entered by configuring the Minimum Value and Maximum Value attributes. This item type automatically checks if the entered value is a number. No extra validations are required. Page Designer attributes: Settings, Minimum Value - Enter the minimum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Maximum Value - Enter the maximum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Number Alignment - Select how to align the number that displays. This setting does not apply when the item is rendered as Read Only or where HTML Form Element Attributes are specified. Appearance, Format Mask - Enter a number format mask to apply to this component. You can type in the format mask or pick from the list of predefined format masks.You can also use substitution syntax to reference a format mask from an application or page item. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Component View attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. Settings, Format Mask - Identify the number format mask used by the item type. You can use substitution syntax to reference a dynamic format mask from an application or page item. Settings, Minimum Value - Enter the minimum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Maximum Value - Enter the maximum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Number Alignment - Select how to align the number that displays. This setting does not apply when the item is rendered as Read Only or where HTML Form Element Attributes are specified.
Password	Renders as an HTML password form element. Page Designer attributes: Settings, Submit when Enter Pressed - Specify whether pressing the Enter key while in this field automatically submits the page. Settings, Does not save state - Specify whether the password is saved in session state. Oracle strongly recommends that you do not write the password into session state, for security reasons. The value can potentially be read from browser cache and Application Express session tables. If you do set this attribute to No, consider setting Store value encrypted in session state to Yes. Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Submit when Enter Pressed - Specify whether pressing the Enter key while in this field automatically submits the page. Settings, Does not save state - Specify whether the password is saved in session state. Oracle strongly recommends that you do not write the password into session state, for security reasons. The value can potentially be read from browser cache and Application Express session tables. If you do set this attribute to No, consider setting Store value encrypted in session state to Yes. See Also: "About Session State and Security".
Popup List of Values (LOV)	Renders as a text field with an icon. When the user clicks the icon, a popup window appears with a list of values represented as a series of links. When the user makes a selection from the list, the selected value is placed in the text field. You control popup lists of values through templates. You can only specify one popup list of values (LOV) template for each application. A popup LOV is a good choice for lists of values that are too large to return on a single page. Popup LOVs must be based on a query that selects two columns with different column aliases. For example: SELECT ename name, empno id FROM emp If one of the columns is an expression, remember to use an alias. For example: SELECT ename\|\|' '\|\|job display_value, empno FROM emp Note: When creating a new item of this type, first select Popup List of Values and then Text Field with Calculator Popup. Page Designer item attributes: Settings, Input Field - Select whether the item is enterable. Settings, Fetch - Select how data is initially fetched for the list of values. Settings, Allow Multi Selection - Allows for multiple, comma separated values to be selected. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Input Field - Select whether the item is enterable. Settings, Fetch - Select how data is initially fetched for the list of values. Settings, Allow Multi Selection - Allows for multiple, comma separated values to be selected. See Also: "Creating a Cascading List of Values" and "Creating a Cascading List of Values"
Radio Group	Renders as an HTML radio group form element, based on a list of values. The following example displays employee names (`ename`), but returns employee numbers (`empno`): SELECT ename, empno FROM emp Page Designer item attributes: Settings, Number of Columns - Enter the number of radio group columns to display. For example, a value of `2` would display two columns. If there were five values then it would display over three rows. Settings, Page Action on Selection - Select what action is taken when a radio group value is selected. See Help for more details. Settings, Execute Validations - Displays if Page Action when Value Changed is set to Submit Page. Controls the execution of validations when a page is submitted. Set this attribute to No to prevent the execution of validations and associated error messages. Set this attribute to Yes to execute all page and built-in validations and associated error messages when the page is submitted. Use this attribute in conjunction with the validation attribute, Always Execute. To learn more, see "About Determining When Validations Execute." See Also: "Creating a Cascading List of Values" and "Creating a Cascading List of Values" Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Number of Columns - Enter the number of radio group columns to display. For example, a value of `2` would display two columns. If there were five values then it would display over three rows. Settings, Page Action on Selection - Select what action is taken when a radio group value is selected.Option includes: None (Default); Submit Page; or Redirect and Set Value. Choose Submit Page to have the page submitted when the radio button is selected. Settings, Execute Validations - Displays if Page Action when Value Changed is set to Submit Page. Controls the execution of validations when a page is submitted. Set this attribute to No to prevent the execution of validations and associated error messages. Set this attribute to Yes to execute all page and built-in validations and associated error messages when the page is submitted. Use this attribute in conjunction with the validation attribute, Always Execute. To learn more, see "About Determining When Validations Execute." See Also: "Creating a Cascading List of Values" and "Creating a Cascading List of Values"
Rich Text Editor	Renders as an HTML text area. There is no maximum length for an item displayed as a text area. You control the height and width by editing the Height and Width item attribute. Page Designer item attributes: Settings, Editor - Select the editor used to display the text formatting options available. Settings, Toolbar - Select the number of text formatting options available within the editor. Settings, Toolbar Expanded - Determines if the toolbar must start expanded when the Rich Text Editor is loaded. Settings, Skin - Select the editor skin used to style the editor. Settings, Toolbar Position - Specify where in the text area the editor displays. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Editor - Select the editor used to display the text formatting options available. Settings, Toolbar - Select the number of text formatting options available within the editor. Settings, Toolbar Expanded - Determines if the toolbar must start expanded when the Rich Text Editor is loaded. Settings, Skin - Select the editor skin used to style the editor. Settings, Toolbar Position - Specify where in the text area the editor displays.
Select List	Displays using a list of values. A list of values is required for items displayed as a select list. Select lists are rendered using the HTML form element `<select>`. The values in a select list are determined using a named list of values or a list of values defined at the item level. You can specify the NULL display value and NULL return value. The following example would return employee names (`ename`) and employee numbers (`empno`) from the `emp` table. Note that column aliases are not required and are included in this example for clarity. SELECT ename display_text, empno return_value FROM emp Page Designer item attributes: Page Action on Selection - Select what action is taken when a list value is selected. Options include: None, Submit Page, Redirect and Set Value, Redirect to Page (based on selected value), or Redirect to URL (based on selected value). Execute Validations - Displays if Page Action on Selection is set to Submit Page. Controls the execution of validations when a page is submitted. Set this attribute to No to prevent the execution of validations and associated error messages. Set this attribute to Yes to execute all page and built-in validations and associated error messages when the page is submitted. Use this attribute in conjunction with the validation attribute, Always Execute. To learn more, see "About Determining When Validations Execute." Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Page Action on Selection - Select what action is taken when a list value is selected. Options include: None, Submit Page, Redirect and Set Value, Redirect to Page (based on selected value), or Redirect to URL (based on selected value). Allow Multi Selection - Enables to select multiple values in the Select List. Use the Height attribute to define how many entries of the Select List should be visible at once. Execute Validations - Displays if Page Action on Selection is set to Submit Page. Controls the execution of validations when a page is submitted. Set this attribute to No to prevent the execution of validations and associated error messages. Set this attribute to Yes to execute all page and built-in validations and associated error messages when the page is submitted. Use this attribute in conjunction with the validation attribute, Always Execute. To learn more, see "About Determining When Validations Execute."
Shuttle	Renders as a multiple select list that includes two boxes containing lists. The left list displays a source list of values. Users use the shuttle control icons and buttons to select list items and move them from the left (source) list to the right (destination) list. Each shuttle has five controls: Move all - Moves all items in the source list to the destination list. Move selected - Moves only selected items (Ctrl + Shift items) to destination list. Remove selected - Moves only selected items (Ctrl + Shift items) to the source list. Remove all - Moves all items on destination list back to the source list. Refresh - Resets the source and destination lists. The right destination list includes the sort controls Move to top, Move up, Move down, and Move to bottom. Page Designer item attributes: Settings, Show Controls - Select what data movement controls displays in the middle of the shuttle. Options include: None, Moving Only, Ordering Only, or All. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Note: To create this item type, you must define a list of values. See "Creating Lists of Values at the Application Level," "Working with Multiple Select List Item," and "Creating a Cascading List of Values." Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Show Controls - Select what data movement controls displays in the middle of the shuttle. Options include: None, Moving Only, Ordering Only, or All. Note: To create this item type, you must define a list of values. See "Creating Lists of Values at the Application Level," "Working with Multiple Select List Item," and "Creating a Cascading List of Values."
Slider	Renders slider item type for jQuery Mobile applications. This item type enables users to use slide handler to set a value. Page Designer item attributes: Settings, Minimum Value - Enter the minimum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Maximum Value - Enter the maximum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Step Increment - Enter a value to force the slider to snap to a specific increment. The value can be a static value or a dynamic value using substitution syntax. Settings, Highlight Selected - Specify whether the slider highlights the track up to the current slider handle position. Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Minimum Value - Enter the minimum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Maximum Value - Enter the maximum value permitted. The value can be a static value or a dynamic value using substitution syntax. Settings, Step Increment - Enter a value to force the slider to snap to a specific increment. The value can be a static value or a dynamic value using substitution syntax. Settings, Highlight Selected - Specify whether the slider highlights the track up to the current slider handle position.
Text Field	Displays the item as a text field. Page Designer item attributes: Settings, Subtype - Select the HTML5 text subtype. This enables devices with on-screen keyboards to show an optimized keyboard layout specific to the subtype, for easier data input. The subtype selection is also used to render an appropriate link with the value of the page item, if it is rendered read only. This attribute does not change the text item, or data entry, when using a physical keyboard. Settings, Trim Spaces - Select how the item value is trimmed after submitting the page. This setting trims spaces, tabs, and new lines from the text entered. Settings, Submit when Enter Pressed - Specify whether pressing the Enter key while in this field automatically submits the page. Settings, Disabled - Specify whether this item is disabled, which prevents end users from changing the value. A disabled text item still displays with the same HTML formatting, unlike an item type of Display Only, which removes the HTML formatting. Disabled text items are part of page source, which enables their session state to be evaluated. Conversely, display only items are not stored in session state. Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Subtype - Select the HTML5 text subtype. This enables devices with on-screen keyboards to show an optimized keyboard layout specific to the subtype, for easier data input. The subtype selection is also used to render an appropriate link with the value of the page item, if it is rendered read only. This attribute does not change the text item, or data entry, when using a physical keyboard. Settings, Trim Spaces - Select how the item value is trimmed after submitting the page. This setting trims spaces, tabs, and new lines from the text entered. Settings, Submit when Enter Pressed - Specify whether pressing the Enter key while in this field automatically submits the page. Settings, Disabled - Specify whether this item is disabled, which prevents end users from changing the value. A disabled text item still displays with the same HTML formatting, unlike an item type of Display Only, which removes the HTML formatting. Disabled text items are part of page source, which enables their session state to be evaluated. Conversely, display only items are not stored in session state.
Text Field with autocomplete	Displays a list of possible values when the user starts typing in the field. The values are based on the defined LOV SQL statement. The following example displays employee names (ename) and stores them in the field: SELECT ename FROM emp ORDER BY 1 Page Designer item attributes: Settings, Search - Select how the search against the entered value is performed. When using Lazy Loading this setting can have an impact on query performance. Selecting Contains & Case Sensitive or Contains & Ignore Case prevents the use of column indexes. Settings, Lazy Loading - Specify whether matching values are retrieved from the database using Lazy Loading techniques. Lazy loading retrieves matching records from the database each time the user types a character. Otherwise, all of the list values are loaded on page load. Oracle recommends using Lazy Loading when you have a large select list, as loading a large number of records may impact the time to initially load the page. Settings, Maximum Values in List - Specify whether the text field is filled automatically with the first autocomplete value. Settings, Automatic Fill - Specify whether the text field is filled automatically with the first autocomplete value. See Help for more details. Settings, Select First - Specify whether the first autocomplete value is automatically selected when the end users hits tab/return, even if it has not been handpicked by keyboard or mouse action. If there is a handpicked (highlighted) result, that result takes precedence. Settings, Highlight Search - Specify whether the matching text is highlighted in the select box of matching entries. Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Search - Select how the search against the entered value is performed. When using Lazy Loading this setting can have an impact on query performance. Selecting Contains & Case Sensitive or Contains & Ignore Case prevents the use of column indexes. Settings, Lazy Loading - Specify whether matching values are retrieved from the database using Lazy Loading techniques. Lazy loading retrieves matching records from the database each time the user types a character. Otherwise, all of the list values are loaded on page load. Oracle recommends using Lazy Loading when you have a large select list, as loading a large number of records may impact the time to initially load the page. Settings, Maximum Values in List - Specify whether the text field is filled automatically with the first autocomplete value. Settings, Automatic Fill - Specify whether the text field is filled automatically with the first autocomplete value. See Help for more details. Settings, Select First - Specify whether the first autocomplete value is automatically selected when the end users hits tab/return, even if it has not been handpicked by keyboard or mouse action. If there is a handpicked (highlighted) result, that result takes precedence. Settings, Highlight Search - Specify whether the matching text is highlighted in the select box of matching entries.
Text Field with Calculator Popup	Renders as a text field with an icon. When clicked, the icon displays a small window containing a calculator. Calculations are placed back in the text field. Note: When creating a new item of this type, first select Popup List of Values and then Text Field with Calculator Popup. Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Allow Multi Selection - Allows for multiple, comma separated values to be selected.
Text Area	Renders as an HTML text area. There is no maximum length for an item displayed as a text area. You control the height and width by editing the Height, Width, and Maximum Width attributes. Page Designer item attributes: Settings, Resizable - Specify whether the text area resizing using the mouse is enabled. Settings, Auto-Height - Specify whether the height of the text area varies based on the amount of text displayed. Use this option to scale the text area to the amount of data. Settings, Character Counter - Select Yes to include a counter that displays the number of characters entered in the field. Settings, Trim Spaces - Select how the item value is trimmed after submitting the page. This setting trims spaces, tabs, and new lines from the text entered. Validation, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a `NOT NULL` validation when the page is submitted. Component View item attributes: Settings, Value Required- If select Yes and the page item is visible, Oracle Application Express automatically performs a `NOT NULL` validation when the page is submitted. Settings, Resizable - Specify whether the text area resizing using the mouse is enabled. Settings, Auto-Height - Specify whether the height of the text area varies based on the amount of text displayed. Use this option to scale the text area to the amount of data. Settings, Character Counter - Select Yes to include a counter that displays the number of characters entered in the field. Settings, Trim Spaces - Select how the item value is trimmed after submitting the page. This setting trims spaces, tabs, and new lines from the text entered.
Yes/No	Displays Flip Toggle Switch in jQuery Mobile user interfaces and as a select list in non-mobile environments. Component View item attributes: Settings, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details. Settings, Settings - Select whether application level component settings are used, or if custom settings are used for this item. Options include: Use Component Settings or Custom. If Settings is set to Custom, the following attributes display: Yes Value; Yes Labe; No Value; No Label. To learn more, see Help. Page Designer item attributes: Settings, Settings - Select whether application level component settings are used, or if custom settings are used for this item. Options include: Use Component Settings or Custom. If Settings is set to Custom, the following attributes display: Yes Value; Yes Labe; No Value; No Label. To learn more, see Help. Validation, Value Required - If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted. See Help for more details.