Database Reference
In-Depth Information
Figure 6-45. APEX page item types
Application items aren't associated with a page and have no UI properties. They
hold values in an application that are essential but not necessarily displayed. You can
use an application item much like a global variable. For example, you may need to cal-
culate sales tax based on the state the user lives in. You could read that sales tax per-
cent from a table when the user logs in and keep the value in an application item for
use throughout the user's session.
The Importance of Bind Variables
When referencing APEX item values, particularly in SQL queries in your APEX ap-
plication, it's important to think about SQL security basics, including SQL injection.
Consider the example of an online form that allows a user to sign on with a username
and password, which ultimately executes this query:
SELECT COUNT(*) FROM users
WHERE username = '&username'
AND password = '&password'
 
Search WWH ::




Custom Search