Oracle APEX Tutorial 5 – Check Boxes – Part 1 – Video Training

kevin.landonTechnical Tips3 Comments

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 their properties to make them work for you, not against you.
We recommend 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

[youtube]http://www.youtube.com/watch?v=UbSpitqmmdA[/youtube]

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, Success, 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

3 Comments on “Oracle APEX Tutorial 5 – Check Boxes – Part 1 – Video Training”

  1. I MA GETTING THIS ERROR WHEN I AM CREATING THE FIRST ITEM
    “ORA-06502: PL/SQL: erro: erro de conversão de caractere em número numérico ou de valor”
    WHY IS THIS ?
    THX

  2. OHH MY BAD IT HAVE PUT IT IN THE LANGUAGE THAT I AM WORKING ON .
    “IT IS AN ERRO ON THE CONVERSION FORM CHARACTER TO NUMBER “

Leave a Reply to ADRIAN Cancel reply

Your email address will not be published. Required fields are marked *