The Apex Guide Oracle Apex Guide RSS Feed


Oracle Application Express

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 


SGA System Global Area
SID The Oracle system identifier that distinguishes the database from all other databases on your computer.
SQL Injection A SQL injection is a form of attack on a database-driven web site in which the attacker executes unauthorized SQL commands by taking advantage of flaws in its code.
To prevent this type of attack do not include arbitrary user input in a SQL query run by your application.
SSL Secure Sockets Layer. SSL is an industry-accepted standard for network transport layer security.
SSO Single Sign-On. A component of Oracle Application Server.
Schema A collection of related database objects. Relational schemas are grouped by database user ID and include tables, views, and other objects.
Multidimensional schemas are called analytic workspaces and include dimensions, relations, variables, and other objects.
Security You can provide security for your application by specifying an authorization scheme. Authorization is a broad term for controlling access to resources based on user privileges.
Security Attributes You can provide security for your application by configuring attributes on the Edit Security Attributes page. The Security Attributes you choose apply to all pages within an application.
Session A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier.
The Application Express engine uses this identifier (or session ID) to store and retrieve an application's working set of data (or session state) before and after each page view.
Session IDs The Application Express engine establishes the identity (or anonymity) of the user for each page request and the session ID to fetch session state from the database.
The visible location of the session ID is in the URL for a page request. Another visible location is in the page's HTML POST data and indirectly in the contents of a session cookie.
This cookie is sent by the Application Express engine during authentication and is maintained for the life of the application (or browser) session.
Session State The behavior of an Oracle Application Express application is usually driven by values in session state. For example, a button may display conditionally based on the value of an item session state.
You can view the session state for a page by clicking Session on the Developer toolbar.
Session State Management APEX transparently maintains session state and provides developers with the ability to get and set session state values from any page in the application.
Session State Protection Session State Protection is built-in APEX functionality that prevents hackers from tampering with the URLs within your application.
Shared Components Shared components are common elements that can display or be applied on any page within an application.
Shortcuts Use shortcuts to avoid repetitive coding of HTML or PL/SQL functions. You can create a shortcut to define a page control such as a button, HTML text, a PL/SQL procedure, or HTML.
Once you define a shortcut it is stored in a central repository so you can reference from various locations within your application.
Substitution Strings Substitution strings are static variables defined at the application level. The value of these variables can be referenced throughout the application using the syntax &STRING_NAME.
For example if your application references a product name frequently, but that name is subject to change, you could define a substitution string PRODUCT_NAME and reference it in a region as follows:
Welcome to the &PRODUCT_NAME. store!
Surrogate Key A column added to a table as the primary key that has no significance to the business, but is used only to join tables together.
This might be done if the business cannot specify a truly unique and stable primary key for the table.

© RuleWorks - All Rights Reserved - Policy - - Sitemap