Part-24

Why is it preferable to create a fewer no. of queries in the data model? -
Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.


Where is the external query executed at the client or the server? -
At the server.


Where is a procedure return in an external pl/SQL library executed at the client or at the server? - At the client.


What is coordination Event? -
Any event that makes a different record in the master block the current record is a coordination causing event.


What is the difference between OLE Server & OLE Container? -
An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.


What is an object group? -
An object group is a container for a group of objects; you define an object group when you want to package related objects, so that you copy or reference them in other modules.


What is an LOV? -
An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.


At what point of report execution is the before Report trigger fired? -
After the query is executed but before the report is executed and the records are displayed.


What are the built -ins used for Modifying a groups structure? - ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)


What is an user exit used for? -
A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.


What is the User-Named Editor? -
A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.


What are the Built-ins to display the user-named editor? -
A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.


What is a Static Record Group? -
A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.