-
What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
-
State the order in which these triggers are executed ?
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.
-
-
-
Can we create two blocks with the same name in form 3.0 ?
No.
rampratap409
- Dec 6th, 2006
no you can not make two blocks with same name,not only block for same type of object you can not have same name.
-
How do you trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
rampratap409
- Dec 6th, 2006
other then on-error trigger , you can use exception also in that blockwith the help of a small procedure and alert you can populate the message and with raise_form_trigger_failure transaction can be controlled.
-
When will ON-VALIDATE-FIELD trigger executed ?
It fires when a value in a field has been changed and the field status is changed or new and the key has been pressed. If the field status is valid then any further change to the value in the field will not fire the on-validate-field trigger.
rampratap409
- Dec 6th, 2006
On-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate.
-
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute-query post-change trigger will fire, on-validate field trigger will not fire.
rampratap409
- Dec 6th, 2006
On-validate field will fire after post-change trigger. if value in field satisfy the validation then also post-change will fire when cursor leaves that field but after key-next
-
When is PRE-QUERY trigger executed ?
When Execute-query or count-query Package procedures are invoked.
rampratap409
- Dec 6th, 2006
Pre-query trigger fires before any execution of a query. this trigger fires only once per query. where as post query fires for each row.
-
-
-
Suppose a form is created ,which is accessed by multiuser.What should be done to prevent the table getting locked
semaj
- Feb 27th, 2007
Create an ON-LOCK trigger and code along these lines ....declare cursor c1 is select * from emp where empno = :emp.empno for update nowait; r1 &nb...
manish
- Sep 17th, 2006
When-new-record-instance--set property 'enter-query mode' YES (default)Use 'For Update Cursor' with 'NoWait' for firing DMLs on table.For Update Clause explicitly lock the table before you fire any DM...
-
-
What is the maximum size of a form ?
255 character width and 255 characters Length.
Kareem
- Apr 3rd, 2007
This is the max number of form name not the entire form size
-
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?
True.
Thileepan
- Jun 12th, 2007
False. It is not a MUST.Using PL/SQL ref cursors we can maintain data retrieval conditions for master / detail blocks. Also we can handle join conditions at run time too.
-
-
-
-
What is an Alert ?
An alert is window that appears in the middle of the screen overlaying a portion of the current display.
kirangsv
- Jan 8th, 2008
Alert is a modal window that displays a warning message on some application that might have unexpected consequences.3 types of alerts: STOP, CAUTION, NOTE.You can even create your own custom alert that displays in response to that specific event
-
Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL FMB ----- Form Module Binary. MMB ----- Menu Module Binary. PLL ------ PL/SQL Library Module Binary.
g_sidhu
- Feb 13th, 2008
.fmb files are binary files; .fmx files are executable files. .pll binary library module.mmb Menu binary source file
Oracle Forms Interview Questions
Ans