Checkbox |
Displays a single checkbox, enabling the user to check or uncheck it.
The checkbox item always has one of two values the checked value or unchecked
value.
Page Designer item attributes:
-
Settings, Use
Defaults - If set to On, the checkbox uses
the application-level component settings defined in Shared Components, Component
Settings, checkbox.
See Also: Configuring Checkbox
If Use Defaults is set to
Off, the following custom settings appear:
-
Checked Value - Enter the value stored
in the page item if the end user checks the checkbox. The value can be up to
255 characters long.
On a Faceted Search page, if the facet filters a query column
based on a List Of Values, this value must match both LOV
display and return value. If display and return values differ, then you
cannot use this facet type for this column - use the Checkbox Group
facet instead.
-
Unchecked Value - Enter the value stored
in the page item if the user unchecks the checkbox. This attribute can also
be left blank if you want to store NULL when checked. The value can be up to
255 characters long.
Note: This value is used if the page item is populated
with a value which does not match either the Checked Value or Unchecked
Value.
|
Checkbox Group |
Displays multiple values as checkboxes, enabling the end user to
select multiple values. A list of values is required for items displayed as
checkboxes. The values corresponding to the checked boxes are stored in a single
colon-delimited string.
Note: For Yes/No checkboxes (that is, a checkbox with only one
value), Oracle recommends using a checkbox or a Switch item type.
The following example displays employee names
(ename ), but returns employee numbers (empno ):
SELECT ename, empno FROM emp;
See Also:
APEX_UTIL in Oracle APEX API
Reference for information about
breaking up returned values
Page Designer item attributes:
- Settings, Number
Columns - Enter the number of layout columns used to display the
checkboxes. For example, a value of 2 would display two columns of checkboxes. By
default, all values display in one column.
- Validation, Value
Required - If set to On and the page item is
visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
See Also: Creating a Cascading List of Values
|
Color Picker |
Displays a control for choosing or entering a color depending on the
Display As setting. End users can enter a color value or select one from an inline
or popup color spectrum.
Page Designer item attributes:
-
Settings, Use
Defaults - If set to On, the Color Picker
uses the application-level component settings defined in Shared Components,
Component Settings, Color Picker.
See Also: Configuring Color Picker Display
If Use Defaults is set to
Off, the following settings appear:
-
Display As - Select how the color picker
displays. Options include:
-
Popup - Displays as a text field
with icon to open the color spectrum picker.
-
Inline - Displays as an inline color
spectrum.
-
Color-only Popup - Displays as a
button which opens the color spectrum popup.
-
Native Color Picker - Displays as a
native browser color input (the UI is dependent on the browser).
-
Mode - Select the amount of information
shown in the color picker. Options include Simple or
Full.
-
Color Preset - Determines if the color
picker should display a set of predefined colors and whether they are from
the theme or custom. Options include None,
Theme Style Colors, or Custom
Colors.
-
Contrast With - Compare the color of
this item with a color from another item or a static value and display the
contrast ratio between them in the color picker UI. Enabling this option can
help the user choose colors with enough contrast to be accessible to
everyone. Options include: None, Page
Item, or Static Color.
-
Return Value As - Specify the format of
the color value returned by this item. Even if the color is entered in a
different valid format it will be presented, returned, and sent to the
server in this format. Options include: Hex,
rgb, rgb/rgba,
hsl, hsl/hsla, or
Any CSS Value. See Help for more details.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX 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. End users can either enter
the date directly into the text item, or click on the calendar icon to select a
date, and optionally a time, from the calendar popup.
Time is only displayed in the calendar popup if the Format Mask for
this item includes time components.
Page Designer item attributes:
-
Settings, Show Time -
Enable this option to include time information.
-
Settings, Display As
- Select the display mode for the date picker. Options include:
-
Popup - Displays in a popup when the
item receives focus, or the calendar icon is clicked.
-
Inline - The calendar always displays
inline on the page. No text field is displayed and the current date
selection is shown highlighted in the calendar.
-
Native HTML - Renders using the native
HTML input date types, if supported by the browser. When 'Show Time' is off,
this renders a 'date' type, when 'Show Time' is on, this renders a
'datetime-local' type. Note: The exact display of these date types is
dependent on the browser. Native HTML may be the preferred option when the
app is being used on a mobile device.
Note regarding using Native HTML.
Because the native date types are very specific about the date format they
require, the item's Format Mask will be automatically set by APEX, and you will not be able to change it. However this will not be the
format displayed to the end user. The end user will see the date in the
format appropriate to their current locale.
-
Settings, Minimum
Date - Specify if this item has a minimum date. Options
include:
-
None - No minimum date defined.
-
Item - Minimum date is derived
dynamically from another item's value.
-
Static - Minimum date is a static value,
defined as either an absolute value, or relative value to today's date.
Additional attributes display conditionally based on the selected
value.
-
Settings, Maximum
Date - Enter the maximum date that can be input or selected.
Additional attributes display conditionally based on the selected value.
-
Settings, Multiple
Months - Determines if the calendar displays multiple months and
how many. Select No to disable this option, or select the
number of month.
-
Settings, Use
Defaults - If set to On, the Date Picker
uses the application-level component settings defined in Shared Components,
Component Settings, Date Picker. See Configuring Date Picker
If Use Defaults is set to
Off, the following attributes appear:
-
Appearance & Behavior - Control the
appearance of the calendar used to select dates. This attribute only applies
when Display As is either
Popup or Inline. Options
include:
- Show Week - Determines whether the
week of the year displays.
- Month Picker - Controls whether the
month renders as a button which enables users to make another selection,
or just as text.
- Year Picker- Controls whether the
year renders as a button which enables users to make another selection, or
just as text.
- Paginate by Multiple Months -
Determines whether pagination size when displaying several months is only
one month or the number of months.
- Show Today Button - Determines
whether a today button displays to select the current date.
- Show Clear Button - Controls whether
a clear button displays to clear the value of the date picker. This
attribute only applies if Display As is set to
Inline.
-
Days Outside Month - Dictates the
behavior of days outside the current viewing month. This attribute only
applies if Display As is set to either
Popup or Inline. Options
include:
- Hidden - Days outside the current
viewing month are hidden.
- Selectable - Days outside the
current viewing month are visible and selectable.
- Visible - Days outside the current
viewing month are visible.
-
Time Increment - Time increment in
minutes used by the time selection control. This attribute is used for
selecting the time of increments that can still be manually entered and
saved.
This attribute is only used when Display
As is set to either Popup or
Inline and Show Time is
enabled.
-
Show On - Controls when the calendar
popup displays. This option is only used when Display
As is set to either Popup or
Inline. Options include:
- Item Focus - When the item receives
focus or when the calendar icon is clicked.
- Icon Click - Only when the calendar
icon is clicked.
-
Appearance, Format
Mask - Enter a date format mask to apply to this component.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
Date Picker (jQuery)
(Desupported) |
Note: The Date Picker (jQuery) item type is desupported and
should no longer be used. Existing apps do not automatically switch to using the new
date picker to preserve possible customizations. You can switch all the date pickers
in your app to use the new date pickers by using Upgrade Application in the
Utilities section of your application in App Builder. See Running Application Upgrade.
Displays a text field with a calendar icon. End users can either enter
the date directly into the text item, or click on the calendar icon to select a
date, and optionally a time, from the calendar popup.
Time is only displayed in the calendar popup if the Format Mask for
this item includes time components.
Page Designer item attributes:
-
Settings, Show Time -
Enable this option to include time information.
-
Settings, Display As
- Select the display mode for the date picker. Options include:
-
Popup Calendar - Displays in a popup
when the item receives focus, or the calendar icon is clicked.
-
Inline - The calendar always displays
inline on the page. No text field is displayed and the current date
selection is shown highlighted in the calendar.
-
Native HTML - Renders using the native
HTML input date types, if supported by the browser. When 'Show Time' is off,
this renders a 'date' type, when 'Show Time' is on, this renders a
'datetime-local' type. Note: The exact display of these date types is
dependent on the browser. Native HTML may be the preferred option when the
app is being used on a mobile device.
Note when using Native HTML. Because
the native date types are very specific about the date format they require,
the item's Format Mask will be automatically set by APEX, and you will not be able to change it. However this will not be the
format displayed to the end user. The end user will see the date in the
format appropriate to their current locale.
-
Settings, Minimum
Date - Specify if this item has a minimum date. Options
include:
-
None - No minimum date defined.
-
Item - Minimum date is derived
dynamically from another item's value.
-
Static - Minimum date is a static value,
defined as either an absolute value, or relative value to today's date.
Additional attributes display conditionally based on the selected
value.
-
Settings, Maximum
Date - Enter the maximum date that can be input or selected.
Additional attributes display conditionally based on the selected value.
-
Settings, Multiple
Months - Determines if the calendar displays multiple months. If
set to On, the Number of Months
attribute appears. Enter the number of months to show at once.
-
Settings, Use
Defaults - If set to On, the Date Picker
uses the application-level component settings defined in Shared Components,
Component Settings, Date Picker.
See Also: Configuring Date Picker
If Use Defaults is set to
Off, the following attributes appear:
-
Appearance - Control the appearance of
the calendar used to select dates. Options include:
- Show Week
- Month Picker
- Year Picker
This attribute is only used if Display
As is set to either Popup or
Inline.
-
Days Outside Month - Dictates the
behavior of days outside the current viewing month. Options include:
- Hidden - Days outside the current
viewing month will be hidden.
- Selectable - Days outside the
current viewing month will be visible and selectable.
- Visible - Days outside the current
viewing month will be visible.
This attribute is only used if Display
As is set to either Popup or
Inline.
-
Time Increment - Time increment in
minutes used by the time selection control. This attribute is used for
selecting the time of increments that can still be manually entered and
saved.
This attribute is only used when Display
As is set to either Popup or
Inline and Show Time is
enabled.
-
Show On - Controls when the calendar
popup is displayed. Options include:
- Item Focus - When the item receives
focus or when the calendar icon is clicked.
- Icon Click - Only when the calendar
icon is clicked.
This option is only used when Display
As is set to either Popup or
Inline.
-
Appearance, Format
Mask - Enter a date format mask to apply to this component.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
Display Image |
Displays an image stored in a database BLOB columns,
or based on an image URL.
Note: Not supported for interactive grid columns.
Page Designer 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, MIME Type
Column - Enter the uppercase page or application item name used to
store the mime type of the uploaded file. The mime type is used by the browser
to identify which application is used to display the content of the BLOB when
the file is downloaded.
-
Settings, BLOB Last Updated
Column - Enter the uppercase page or application item name that
holds the date column value when the associated BLOB was last
updated. This value is used for browser caching and to identify if the image has
been changed since the last request from the browser. If the image is not
updated then the image is retrieved from the browser cache, if available.
|
Display Map |
Displays a map based on coordinates in GeoJSON point format.
Page Designer item attributes:
- Settings, Background - Select the
background map to use. See Help for more details.
- Settings, Zoom Level - Specify the
zoom level for this layer to become visible. Minimum value is 1. Maximum value is
18.
- Settings, Show Marker - Specify
whether a marker should be displayed..
- Settings, Marker Color - Specify
the marker fill color. See Help for more details.
- Settings, Tooltip - Specify the
tooltip text for a displayed marker. The tooltip attribute supports HTML and APEX template directives.
- Settings, Show Map Controls -
Specify whether map controls should be displayed. This adds zoom and rotation
controls to the map.
- Settings, Interactive Map -
Specify whether the map should be interactive. If disabled, it creates a static
map with no interactivity.
- Settings, Height - Specify the
height (in pixels) of the displayed map. Map's default height is calculated based
on it's width with an 3:2 aspect ratio.
|
Display Only |
Displays a non-enterable text item.
Page Designer item attributes:
- Settings, Format - Options include
Plain Text, HTML, or
Markdown.
- 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.
- Settings, Show Line Breaks -
Select On to convert line breaks in the display value to an
HTML line break and display them in HTML output.
- Settings, Send On Page
Submit - Specify whether the current item value should be sent when
the page is submitted.
- Session State, Data
Type - Select the data type of the page item
(
VARCHAR2 or CLOB ).
- Session State,
Storage - Select how session state is maintained. Options
include:
- Per Request (Memory Only) - Do not save
state in the database. State is only available when processing the current
request. When AJAX requests need to use an item, make sure to pass the item
name using Page Items To Submit.
- Per Session (Persistent) - Maintain for each session
by storing the value in the database, to access it across requests.
|
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.
Note: Not supported for interactive grid columns.
See Also:
About Securing File Uploads
Page Designer attributes:
- Settings, Display As - Select a
display style for how the file browse item should be displayed. See Help for more
details.
- Settings, Dropzone Title - Specify
the title for the Dropzone. If this field is left blank, the Text Messages
APEX.ITEM.FILE.DROP_FILE or
APEX.ITEM.FILE.DROP_FILES will be used by default.
-
Settings, Storage
Type - Identify where the uploaded file is stored. Options
include:
-
BLOB column specified in Item Source
attribute - Stores the uploaded file in the table used by
the Automatic Row Processing (DML) process and the column specified in the
item source attribute. The column has to be of data type
BLOB . If the file gets downloaded, the table name of
the Automatic Row Fetch process is used.
-
Table APEX_APPLICATION_TEMP_FILES -
Stores the uploaded file(s) in a temporary location that you can access with
the view APEX_APPLICATION_TEMP_FILES . Oracle APEX will automatically delete the file(s) at the end of the session or at the
end of the upload request, depending on what you choose for Purge
File At.
If Storage Type is Table
APEX_APPLICATION_TEMP_FILES:
-
Purge File at - Define when Oracle APEX should remove the temporary file.
-
Allow Multiple Files - Specify whether
multiple files can be uploaded at once. Multiple file names will be stored
as a colon delimited list in the page item..
-
File Types - Specify a comma delimited
list of file types which might be used by the browser to restrict which
files can be uploaded.
If Storage Type is BLOB column specified in Item
Source:
-
MIME Type Column - Enter the uppercase
page or application item name used to store the mime type of the uploaded
file. The mime type is used by the browser to identify which application is
used to display the content of the BLOB when the file is downloaded.
-
Filename Column - Enter the page or
application item used to store the filename of the uploaded file. .
-
Character Set Column - Enter the
uppercase page or application item name used to store the character set of
the uploaded file. The character set of the BLOB is not
automatically set on upload. End users should set the character set for the
document they are uploading.
-
BLOB Last Updated Column - Enter the
uppercase page or application item name used to store the current timestamp
when a file is uploaded. This date value is used for browser caching.
-
Display Download Link - Specify whether
the download link displays when there is a non-empty BLOB associated with
this item.
-
Download Link Text - Enter the text that
displays as part of the download link. If not specified, the text stored in
the Text Message
for APEX.FILE_BROWSE.DOWNLOAD_LINK_TEXT within Shared
Components, displays.
-
Content Disposition - Select how the
browser handles the content when downloading.
-
Settings, File Types - Specify a comma
delimited list of file types which might be used by the browser to restrict
which files can be uploaded. See Help for examples.
|
Geocoded Address |
Provides Geocoding functionality that turns a postal address to a
coordinate.
Geocoding is performed by the browser using a REST request to the
Oracle Elocation Geocoding Service (https://elocation.oracle.com/elocation/home.html). In order for geocoding
to work, the user's browser must be connected to the internet.
Geocoding input data comes from other page items which are mapped to
parts of an address such as Street, House Number, Postal Code, or City. The Geocoder
displays a popup window with a list of possible matches. After choosing a match, the
item's session state value will be the address coordinate in GeoJSON format.
The Structured Address attribute determines
whether the address parts are provided to the geocoding service in a
structured or unstructured manner. Structured means that
explicit page items are mapped to address parts such as Street, Postal Code, City or
Region. A structured address has more accurate geocoding results, and also allows
for address correction to be sent back to the page item. Unstructured means
that only one item is used for the whole address and the address parts are separated
by comma. Unstructured mode does not support address corrections.
A Geocoded Address item needs at least one other input item to work
and for an exact address requires a maximum of eight input items.
If Structured Address is Off, the item maps to
only one text field or text area where end users enter address parts, separated by
comma. Following item attributes display under Settings the
Property Editor in Page Designer:
-
Country Type - Select whether to use a
static country for geocoding, or whether to derive the country from an item.
Options include: Static or
Item.
-
Country - Select the country to use for
geocoding.
-
Structured Address - Select
Off. Determines whether address parts are provided to
the geocoding service in a structured or unstructured manner.
-
Address Item - Select the item containing
unstructured address parts, separated by a comma.
-
Match Vector Item - Select a page item for
the Geocoder to return the Match Vector. The match vector is a 17-digit string
with detailed information about how each address attribute has been matched
against the data used for geocoding. See item Help for more details.
-
Trigger Geocoding - Determines when to
trigger geocoding. This includes the browser performing the REST request to the
geocoding service and showing the popup window with possible matches. Options
include: Automatic, Dynamic
Action, and jQuery Selector. See item Help
for more details.
If Structured Address is On, the following item
attributes display under Settings the Property Editor in Page
Designer:
-
Country Type - Select whether to use a
static country for geocoding, or whether to derive the country from an item.
Options include: Static or
Item.
-
Country - Select the country to use for
geocoding.
-
Structured Address - Select
On. Determines whether address parts are provided to
the geocoding service in a structured or unstructured manner.
-
Sanitize Address - Enable this switch to
feed address data from the geocoding service back to the mapped items.
-
Street Item - Select the item containing
the Street part of the address.
-
House Number Item - Select the item
containing the House Number part of the address.
-
Postal Code Item - Select the item
containing the Postal Code part of the address.
-
City Item - Select the item containing
the City part of the address.
-
City Sub Area Item - Select the item
containing the City Sub Area part of the address.
-
Match Vector Item - Select a page item
for the Geocoder to return the Match Vector into. The match vector is a
17-digit string with detailed information about how each address attribute has
been matched against the data used for geocoding. See item Help for more
information.
-
Trigger Geocoding - Determines when to
trigger geocoding. This includes the browser performing the REST request to
the geocoding service and showing the popup window with possible matches.
Options include: Automatic, Dynamic
Action, and jQuery Selector. See item
Help for more information.
Note: The Geocoded Address and Display Map items both work with
the Oracle Elocation Map Cloud service (https://maps.oracle.com/elocation/ajax/index.jsp). This service is
accessed by the browser, not by the APEX database on the server. Be aware this may result in data protection consequences
for users. The geocoding items as and display map items store a coordinate in
GeoJSON format (https://de.wikipedia.org/wiki/GeoJSON) Note
that only the "geometry" portion is used. Currently only "Point" geometries are
supported, for example:
{
"type": "Point",
"coordinates": [
13.74081,
51.05363
]
}
|
Hidden |
Items that are included within the page source but are not rendered.
Hidden item values are saved in session state. They are generally used to store
values required by page processing or other page items, but should not be displayed
to the end user.
Page Designer attribute:
- Settings, Value is
Protected - Select On to prevent hidden
values from being manipulated when a page is posted.
- Session State, Data
Type - Select the data type of the page item
(
VARCHAR2 or CLOB ).
- Session State,
Storage - Select how session state is maintained. Options
include:
- Per Request (Memory Only) - Do not save
state in the database. State is only available when processing the current
request. When AJAX requests need to use an item, make sure to pass the item
name using Page Items To Submit.
- Per Session (Persistent) - Maintain for each session
by storing the value in the database, to access it across requests.
|
Markdown Editor
|
Displays a simple text editor that enables you to use Markdown
shorthand syntax to add formatting to text.
Note:Markdown Editor is not supported for interactive grid
columns.
See Also: Markdown Guide
Page Designer item attributes:
|
List Manager |
Displays a text item with a popup list of values
icon, Add and Remove buttons, and a list of selected values.
Note: Not supported for interactive grid columns.
You can type in the value or pick from the list of available items. You
can then utilize the buttons to manage the values selected. The selected values are
stored in a single colon-delimited string.
Page Designer attributes:
-
Settings, Fetch -
Select how data is displayed when the Popup LOV is opened.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
See Also: Creating a Cascading List of Values
|
Number Field |
Displays as a number field and supports automatic formatting. Numbers
are formatted on the client after data entry according to the format mask. This item
type automatically checks if the entered value is a number. No extra validations are
required. Validation is done on both client and server.
Page Designer attributes:
-
Appearance, Format
Mask - Specifies how the number is to be formatted for display.
The locale determines the decimal separator used for data entry.
-
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.
-
Settings, Virtual
Keyboard - Select which virtual keyboard to display when using the
number field on a touchscreen. Options include:
- Decimal - Numeric only keyboard, with an
added decimal key.
- Numeric - Numeric only keyboard. This
option is useful for monetary values, PIN, ZIP Codes, CC numbers, and so
on.
- Text - Regular alphanumeric
keyboard.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted.
You can replace the predefined error text with an application
specific error message, by defining a message called
APEX.PAGE_ITEM_IS_REQUIRED in Shared Components, Text
Messages. Specify the message display location by updating the application-level
setting, Default Error Display Location.
|
Password |
Displays an HTML password form element. As the end user enters text a
black dot is displayed for that character, instead of the actual character
entered.
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 APEX session tables. If you do set this attribute to No, consider setting Store
value encrypted in session state to Yes.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
See Also:
About Session State and Security
|
Percent Graph |
Displays the value as a percentage graph. The value retrieved must be
between 0 and 100.
|
Popup LOV |
Displays a text item with a popup list of values icon. When the end
user clicks the icon, a popup window appears with a search field, and a list of
supported values.
Popup LOV is best suited for large lists since end users can enter
search criteria to reduce the available values displayed. For relatively small
lists Select List is often better suited.
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
Page Designer item attributes:
-
Settings, Display As
- Selects how the results are displayed either an inline popup or modal
dialog.
-
Settings, Initial
Fetch - Select how data is initially fetched for the list of
values. This applies only the first time the popup is opened after the page
loads or the item is refreshed such as due to a cascade. See also attribute
Minimum Characters.
-
Settings, Multiple
Values - Specifies if multiple values can be selected or
entered.
-
Settings, Manual
Entry - Select whether or not manual entry is allowed.
-
Validation, Value
Required- If set to On and the page item is
visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
See Also: Creating a Cascading List of Values
|
Radio Group |
Displays multiple values as radio group options, enabling the end user
to select a single value.
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 - This attribute only appears 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 Off to prevent the
execution of validations and associated error messages. Set this attribute to
On to execute all page and built-in validations and
associated error messages when the page is submitted.
See Also: About Determining When Validations Execute and Creating a Cascading List of Values
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
Rich Text Editor |
Displays a text area with comprehensive text formatting options. End
users can enhance the content displayed in a similar fashion to using a word
processor, such as Microsoft Word. End users can also cut and paste documents that
are in rich text format (RTF) file format into this item.
Page Designer item attributes:
- Settings, Format -
Specify the output format of the content entered in the rich text editor. Options
include:
- HTML - Use HTML for the source and output
of this rich text editor. HTML is more flexible and offers more formatting
options than Markdown, but is less secure and must be trusted or sanitized
when displayed.
- Markdown - Use Markdown format for the
source and output of this rich text editor. Markdown is more restrictive than
HTML in terms of features, but is more secure as it must first pass through a
parser before being displayed.
- If Settings, Format is
set to HTML, the following additional attributes appear:
- Settings, Toolbar -
Select the number of text formatting options available within the editor.
Available options include: Basic,
Intermediate, or Full.
- Settings, Toolbar
Style - Choose whether the toolbar items should only take up one
line and overflow into a popup menu if wider than the editor's width, or
whether to split them into multiple lines. Options include:
Overflow Menu or
Multiline.
-
Settings, Allow Custom
HTML - Enables the General HTML Support and Source Editing
CKEditor5 plug-ins. Combined, these bridge the gap between CKEditor4 and
CKEditor5, by allowing for custom HTML and the ability to edit it inline.
Oracle recommends disabling this attribute since it is intended for advanced
usage and compatibility with content produced by CKEditor4. See Help for
more details.
- Settings, Minimum
Height - Set the minimum height in pixels of the editable area.
- Settings, Maximum
Height - Set the maximum height in pixels of the editable area.
Leaving this attribute empty will let the editor grow infinitely as you type.
- Validation, Value
Required - If set to On and the page item is
visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
- Session State, Data
Type - Select the data type of the page item
(
VARCHAR2 or CLOB ).
- Session State,
Storage - Select how session state is maintained. Options
include:
- Per Request (Memory Only) - Do not save
state in the database. State is only available when processing the current
request. When AJAX requests need to use an item, make sure to pass the item
name using Page Items To Submit.
- Per Session (Persistent) - Maintain for each session
by storing the value in the database, to access it across requests.
|
Select List |
Displays an item with a built-in list of values selector. When the end
user clicks the item, the list of supported values displays directly inline with the
current item.
Select List is best suited for relatively small, discrete lists. End
users can very quickly select a value from the list without needing to change focus
to a popup dialog. For large lists, consider using a Popup LOV.
select [displayValue],
[returnValue]
from ...
where ...
order by ...
Page Designer item attributes:
-
Settings, Page Action on
Selection - Select what action is taken when a list value is
selected. See help for options.
- Settings, Allow Multi
Selection - Specify whether multiple values or only a single value
can be selected from the list of values. Multiple values are returned as a
comma-separated list.
-
Settings, 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
Off to prevent the execution of validations and
associated error messages. Set this attribute to On 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.
See Also: About Determining When Validations Execute
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
Shuttle |
Displays as a multiple select list that includes two boxes containing
lists. The left list displays the source list of values that have not been selected
and the right list shows the currently selected values. End users can select one or
more values in a list then use the shuttle controls to move the selected values or
all values.
The current values are stored in a single colon-delimited string.
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 set to On and the page item
is visible, Oracle APEX 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.
|
Star Rating
|
Displays a star rating (maximum of 10) that end users can click to set
a numeric value.
Page Designer item attributes:
-
Settings, Number of
Stars - Set the total number of stars (one to ten) for end users
to choose (default five).
-
Settings, Use
Defaults - If set to On, the Star Rating
uses the application-level component settings defined in Shared Components,
Component Settings, Star Rating.
See Also: Configuring Star Rating
If Use Defaults is set to
Off, the following custom settings appear:
- Icon - The icon class to use (such as
fa-thumb-up ). Click the drop-down list to pick an
icon.
- Active Color - Default color for active
stars.
- Inactive Color - Default color for
inactive stars.
- Tooltip - The template for the tooltip
when end users hover the mouse over the item. This rating value replaces the
#VALUE# substitution (for example, the movie rating is
#VALUE# ).
- Show Clear Button - Choose whether to
display the Clear button (
x ) next to the stars.
- Show Value - Choose whether to display a
value next to the stars.
- Read Only Display - Choose what to
display if the item is read only. Options include
Stars, Value, Stars
and Value, and Single Star and
Value.
|
Switch |
Displays as a flip toggle switch.
Page Designer item attributes:
-
Settings, Use
Defaults - If set to On, the Color Picker
uses the application-level component settings defined in Shared Components,
Component Settings, Color Picker.
Note: Switch items can display as a flip toggle switch (the
default), Pill Button, or Select List. See Configuring Switch Defaults.
If Use Defaults is set to
Off, the following custom settings appear:
-
On Value - Enter the value stored in
the page item if the user picks the On option. The value can be up to 255
characters long.
-
On Label - Enter the text displayed for
the On option.
-
Off Value Enter the value stored in the
page item if the user picks the Off option. This attribute can also be left
blank if you want to store NULL when the Off option is selected. The value
can be up to 255 characters long.
Note: This value is used if the page
item is populated with a value which does not match either the On Value or
Off Value.
-
Off Label - Enter the text displayed
for the Off option.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
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.
Note: This HTML5 feature only works in modern browsers.
Older, non HTML5-compliant, browsers ignore this attribute and render the page
item as a normal text field.
-
Settings, Trim
Spaces - Select how the item value is trimmed. This setting trims
spaces, tabs, and new lines from the text entered. Options include:
Leading, Trailing,
Leading and Trailing, or
None.
-
Settings, Text Case
- Select how the item value text case is transformed. Options include:
No Change, Lower, and
Upper.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
Text Field with
autocomplete |
Displays a text field that displays a list of possible values based on
the text already entered by the end user, inline with the text item. The list is
further refined as the end user types in more text.
select [column]
from ...
where ...
order by ...
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, Fetch On
Type - Specify whether matching values are retrieved from the
database as the user types on the autocomplete item. Fetch On
Type 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 Fetch On Type when
you have a large select list since loading a large number of records may impact
the time to initially load the page.
-
Settings, Maximum Values in
List - Enter the maximum number of items to display in the select
box. This value can help avoid performance problems by returning too many rows,
and also prevent a very large return set when only a few letters have been
entered.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
|
Textarea |
Displays a multiple-row text area.
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 - If set to On include a counter
that displays the number of characters entered in the field.
-
Settings, Trim
Spaces - Select how the item value is trimmed. This setting trims
spaces, tabs, and new lines from the text entered. Options include:
Leading, Trailing,
Leading and Trailing, or
None.
-
Validation, Value
Required - If set to On and the page item
is visible, Oracle APEX automatically performs a NOT NULL validation when the page is submitted. See
Help for more details.
- Session State, Data
Type - Select the data type of the page item
(
VARCHAR2 or CLOB ).
- Session State,
Storage - Select how session state is maintained. Options
include:
- Per Request (Memory Only) - Do not save
state in the database. State is only available when processing the current
request. When AJAX requests need to use an item, make sure to pass the item
name using Page Items To Submit.
- Per Session (Persistent) - Maintain for each session
by storing the value in the database, to access it across requests.
|