-
How can a button be used in a report to give a drill down facility?
By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.
-
What are the two ways by which data can be generated for a parameters list of values?
1. Using static values.2. Writing select statement.
-
What are the two panes that Appear in the design time pl/sql interpreter?
1.Source pane. 2. Interpreter pane
-
What are three panes that appear in the run time pl/sql interpreter?
1.Source pane. 2. interpreter pane. 3. Navigator pane.
-
What are the different file extensions that are created by oracle reports?
Rep file and Rdf file.
-
-
-
What is lexical reference? How can it be created?
Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.
-
What is bind reference and how can it be created?
Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.
-
What use of command line parameter cmd file?
It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
-
-
-
-
-
What is term?
The term is terminal definition file that describes the terminal form which you are using r20run.
-
What is use of term?
The term file which key is correspond to which oracle report functions.
-
-
What are the sql clauses supported in the link property sheet?
Where start with having.
-
-
Oracle Concepts Interview Questions
Ans