My Oracle Support Banner

How to Create a DataBound CheckBox in a UIX Page (Doc ID 316851.1)

Last updated on JANUARY 22, 2020

Applies to:

Oracle JDeveloper - Version and later
Information in this document applies to any platform.


This bulletin explains how to define a databound check box in a UIX page.

Traditionally in an Oracle database, the kind of boolean choice that you want to expose through a checkbox has been defined as a simple character column on the table for instance VARCHAR2(1), using the valid values "Y" or "N" to indicate the boolean state.
The technique outlined in this bulletin is based on this scenario, but will work just as well with any kind of boolean storage, for instance a CHAR or NUMBER.
In this example we'll be working with a table including a column called IS_VALID. In the database schema this is defined as being NOT NULL, and has a check constraint to enforce valid values of "Y" or "N". Before we proceed I'll assume that you've already defined your business service and the relevant data control is available in the Data Control Palette.


Oracle ADF developers who want to implement a databound check box in a UIX page.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Creating the UI
 Handling an Unchecked Checkbox
 Application Example

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.