-
-
-
-
Valid settings for the Initial Value property
In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three)A. $$DBDATE$$B. :Orders.Order_date+3C....
dornalpr
- Jun 2nd, 2011
Valid values are: A, B & DIn forms, to give initial value as sysdate, we should user $$DBDATE$$ which gives the current time of server, which stores date of DD-MON-YYYY format. If you want to stor...
-
Name the two files that are created when you generate the form give the filex extension ?
INP (Source File) FRM (Executable File)
parash_3380
- May 4th, 2006
Hiit create two files with extension FMB - Contains source codeFMX - It is executable file.
Amit Chintawar
- Mar 29th, 2006
FMB- You can open this fileFMX- This is in Executable mode, you cannot open this file
-
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.
-
Can we use GO-BLOCK package in a pre-field trigger ?
No.
-
What ERASE package procedure does ?
Erase removes an indicated global variable.
anitha palla
- Aug 13th, 2010
Erase removes an indicated global variable and releases the memory associated with it.
-
How does the command POST differs from COMMIT ?
Post writes data in the form to the database but does not perform database commitCommit permanently writes data in the form to the database.
younaskhan40
- Apr 20th, 2010
POST?will temporary?save?data in the relevant table.If you do not use commit after post then the temporary saved data will be lost.COMMIT permanently Save Data in the table
-
What are the type of User Exits ?
ORACLE Precompliers user exitsOCI (ORACLE Call Interface)Non-ORACEL user exits. Page :
sumanpani
- Sep 16th, 2008
You can write the following types of user exits: ORACLE Precompiler user exits OCI (ORACLE Call Interface) user exits Non-ORACLE user exits User exits can perform the following tasks: ...
-
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
-
What is a Layout Editor?
The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.
g_sidhu
- Feb 13th, 2008
The Layout Editor is a graphical design facility for creating and arranging interface items and graphic objects in a form. In the Layout Editor, you work on a single canvas. Canvases are displayed in ...
-
What do you mean by a block in forms4.0?
Block is a single mechanism for grouping related items into a functional unit for storing, displaying and manipulating records.
g_sidhu
- Feb 13th, 2008
Canvases serve as physical containers of items. Blocks, on the other hand, serve as logical containers of items. There are two types of blocks: basetable blocks and non-base-table blocks. Sometimes, y...
-
List the Types of Items?
Text item. Chart item. Check box. Display item. Image item. List item. Radio Group. User Area item.
-
What is a Check Box?
A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either "checked" or "unchecked".
g_sidhu
- Feb 13th, 2008
Check boxes have two states, checked and unchecked. Very often they are used when the value must be either Yes/No, On/Off,Accept/Decline, etc.
Oracle Forms Interview Questions
Ans