How to Use Checkbox Group Item in Oracle Apex?

How to Use Checkbox Group Item in Oracle Apex?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

In Oracle Apex, you can use a checkbox group item to display multiple value checkboxes. The advantage of using a checkbox group is that you can get all the checkbox values in a single string, each value separated by a colon.

To create the checkbox group item in Oracle Apex follow these steps:

Creating Checkbox Group Item in Oracle Apex

  1. On your page region, right-click, then choose Create Page Item option.
  2. In the property palette, from the items drop-down, select the checkbox group item.
  3. Then from the List Values property, select the source type. You can specify static to specify the fixed values.

Now you can save the changes and run the page to test. The checkbox group item will display multiple checkboxes with the values you specified for the static items.

Getting the Checkbox Group Selected Values

To get the selected checkboxes values, you can use the following SQL query:

select column_value chkbox_value from table(apex_string.split(:P1_YOURCKBOX,':'));

Using the above SQL query, you will get all the values in separate rows.