Introduction

Within APEX, there are a multitude of things you can use Check Boxes for, and many ways they
can be used to improve your application. This tutorial will focus on some of the things you can
use them for, as well as how to set thier properties to make them work for you, not against you.
We reccomend you review our article APEX Tutorial Preparation and OEHR Sample Data Install if
you haven’t already, as this tutorial requires the OEHR Sample Data to work properly.

Part 1 - Base Application, Form Editing and Display Changes

High Level Steps

1) Create and Test base Application. (0:35)
2) Edit the Update Form (3:15)
3) Change Report Display. (8:04)

Times in parenthesis are the approximate start times for those steps

Notes and Resources

DUAL Table

The built in ‘DUAL’ table is a generic dummy table that allows you to perform set mathmatical
functions, or direct assignment of values using a SQL call. In this case we are force selecting
Y anywhere the values of the List and Min price meet the conditions in the WHERE clause.

Code and Entered Text

New Item Name, it’s LOV, Attribute Label and Source SQL Query

P2_SET_MIN_PRICE.

STATIC:Yes;Y,No;N

SET Minimum Price.

SELECT 'Y' FROM DUAL WHERE :P2_LIST_PRICE*0.75=:P2_MIN_PRICE

Process Name,SQL code,Sucess,Failure Messages, and Conditions.

UPDATE Min Price.

UPDATE oehr_product_information
SET MIN_PRICE=(:P2_LIST_PRICE*0.75)
WHERE PRODUCT_ID=:P2_PRODUCT_ID;

Product successfully updated.

Unable to update this product. Contact your system administrator.

P2_SET_MIN_PRICE

Label and LOV for P2_SET_MIN_PRICE

SET Minimum Price.

STATIC: <b> Set Minimum Price</b>
 (25% Discount on List Price);Y

Related Information:

1. Oracle APEX Tutorial 5 – Check Boxes – Part 2 – Video Training Within APEX, there are a multitude of things you can use Check Boxes for, and many ways they can...
2. Oracle APEX Tutorial 4 – Form Layout – Part 3 – Video Training APEX gives you a lot of power and flexibility with its built in wizards. They are very good at creating...
3. Oracle APEX Tutorial 4 – Form Layout – Part 2 – Video Training APEX gives you a lot of power and flexibility with it's built in wizards. They are very good at creating...
4. Oracle APEX Tutorial 4 – Form Layout – Part 1 – Video Training APEX gives you a lot of power and flexibility with its built in wizards. They are very good at creating...
5. Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...
6. Oracle APEX Tutorial 9 - JavaScript - Video Training JavaScript is everywhere on the Internet today. Even if you don't realize it, this handy little scripting tool has become...
7. Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...
8. Oracle APEX Tutorial 3 - Drilldown Report Part 2- Video Training This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a Drilldown Report...