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
SELECT 'Y' FROM DUAL WHERE :P2_LIST_PRICE*0.75=:P2_MIN_PRICE |
SELECT 'Y' FROM DUAL WHERE :P2_LIST_PRICE*0.75=:P2_MIN_PRICE
Process Name, SQL code, Success, Failure Messages, and Conditions.
UPDATE oehr_product_information
SET MIN_PRICE=(:P2_LIST_PRICE*0.75)
WHERE PRODUCT_ID=:P2_PRODUCT_ID; |
UPDATE oehr_product_information
SET MIN_PRICE=(:P2_LIST_PRICE*0.75)
WHERE PRODUCT_ID=:P2_PRODUCT_ID;
Product successfully updated. |
Product successfully updated.
Unable to update this product. Contact your system administrator. |
Unable to update this product. Contact your system administrator.
Label and LOV for P2_SET_MIN_PRICE
STATIC: <b> Set Minimum Price</b>
(25% Discount on List Price);Y |
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”
I am new on oracle APEX, I am very happy of found this Web site thank you.
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
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 “