-
What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
-
Explain types of Block in forms4.0?
Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block...
-
-
-
-
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
PRE-QUERY fires once. POST-QUERY fires 10 times.
-
What is a window?
A window, by itself , can be thought of as an empty frame. The frame provides a way to interact with the window, including the ability to scroll, move, and resize the window. The content of the window i.e. what is displayed inside the frame is determined by the canvas View or canvas-views displayed...
-
List the editors availables in forms 4.0?
Default editor User_defined editors system editors.
-
What is an Lov?
A list of values is a single or multi column selection list displayed ina pop-up window
-
What is the built-in used to get and set lov properties during run-time?
Get_lov_property Set_lov_property Record Group
-
What is a record Group?
A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
-
Give built-in routine related to a record groups?
Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) Add_group_column(Function) Add_group_row(Procedure) Delete_group_row(Procedure) Populate_group(Function) Populate_group_with_query(Function) Set_group_Char_cell(procedure)
-
-
-
How do you pass the parameters from one form to another form?
To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure...
-
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr
-
Convert rdf data into excel format
How to convert rdf data into excel format directly report builder when the report is initialized then output of this report into excel?
-
-
-
Data which are checked in control block should be populated in detailed block
hello,i am facing one problem. I have one main form. In that when i press one button, one window will be pop up with the details of Orders for the particular supplier which was selected in main form. I will check only few orders which i need and when ever i click submit, those checked records should populate in the detailed grid. Popup window is based on control block.One record it is populating. But...
Oracle Forms Interview Questions
Ans