Oracle Reports

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
 

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]
Sep 102014
 

Top 51 Questions for Oracle Reports that are frequently asked in Interview. What is Oracle Developer? What is a Report Builder? What are the various styles used in the Reports? What is GUI? What are the different Report Builder Components? What is a difference between Object Navigator and property Palette? What is a Syntax Palette?

[Read More]
Aug 042014
 

You can also purchase my ebook- Oracle Developer 2000 (D2K) from amazon. Question 1: What is Oracle Developer? Oracle Developer consists of Oracle Components that are helpful in designing the meaningful applications. Question 2: What is a Report Builder? Report Builder is a component of Oracle Developer that is used to display data in a

[Read More]