Oracle D2K

Jan 152015
 

Editors in Oracle Forms Editors are used for special requirements such as: larger editing window, Search/Replace, cut, copy, paste etc. Types of Editors Default Editor System Editor User-Named Editor Default Editor: The default editor provides standard editing features, including search/replace and cut, copy, and paste. The default editor is built into every form and is

[Read More]
Nov 252014
 

Built-in Subprogram is divided into two categories: Restricted Built-in Subprograms Unrestricted Built-in Subprograms Restricted Built-In Subprograms: Restricted built-in affects navigation in your form either external screen navigation or internal navigation. You can call these built-ins only from triggers where no internal navigation is occurring. Restricted built-ins cannot be called from the Pre and Post triggers

[Read More]
Nov 032014
 

Input Items are those items that accepts user Input. Input items enables insert, update, delete or query an item process. Types of Input Items: Check Box: Check Box is a two-state interface object that indicates whether a certain value is Checked or unchecked. Trigger associated with check box is WHEN-CKECKBOX-CHANGED. WHEN-CHECKBOX-CHANGED: This Trigger fires whenever

[Read More]
Oct 152014
 

Oracle Forms Object Group Object Group is used to package related Form Builder objects so that they can be copied or used in another module. For Example: You might build an appointment scheduler in a form and then decide to make it available from other forms in your applications. The scheduler would probably be built

[Read More]
Oct 012014
 

Triggers are blocks of PL/SQL code that is written to perform some specific tasks. Trigger is a program unit that is executed or fired due to an event. Triggers can be fired for events such as: Query-related events During validation or navigation events For error or messages During Post or Commit process etc. Trigger consists

[Read More]
Sep 262014
 

Messages in Oracle Forms Messages and Alerts are the form of communication between the application and the User. Types of Messages: Informative message Error message Working message Application message Informative Message informs the user about the current state of processing. Example: Last value retrieved Press [Accept] to enter answer. Informative messages can be suppressed with

[Read More]
Sep 242014
 

Lexical Parameter in Oracle Reports  Lexical parameters performs dynamic SQL query. Lexical parameters are used to change the data definition at runtime. Use Lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH. Is denoted by ‘&’. You cannot make lexical references in a

[Read More]
Sep 242014
 

Canvas is a surface inside a window on which visual objects can be placed. A canvas is assigned to a window. Each item in a form must refer to not more than one canvas. Types of Canvases: Content Canvas Stacked Canvas Toolbar Canvas Vertical Toolbar Horizontal toolbar Tab Canvas Content Canvas is a base canvas

[Read More]
Sep 242014
 

There are five different types of Report Builder Triggers: Before Parameter Form After Parameter Form Before Report Between Pages After Report Before Parameter Form Trigger fires before the Runtime Parameter Form is displayed. From this Trigger, you can access and change the value of parameters, PL/SQL Global variables and report-level columns. If the runtime parameter

[Read More]
Sep 222014
 

Types of Columns in Oracle Report Builder Four different types of Columns in Oracle Reports are: Data Columns, Formula Columns, Summary Columns and Placeholder Columns. Data Columns: Data Columns contain the data values for a report. Data Columns are corresponding to the table columns included in the select list of a query. Each column is

[Read More]