-
Can you change the alert messages at run-time?
If yes, give the name of the built-in to change the alert messages at run-time. Yes. Set_alert_property.
g_sidhu
- Feb 14th, 2008
You can use the SET_ALERT_PROPERTY built-in to set the title of the alert and the alert’s message text programmatically.SET_ALERT_PROPERTY(v_alert_id,ALERT_MESSAGE_TEXT, 'areyousureyouwanttoexittheform?');
-
What is the built-in function used for finding the alert?
Find_alert Editors
g_sidhu
- Feb 14th, 2008
FIND_ALERT will find the alert’s object ID, which you can then use in the SHOW_ALERT built-in or the SET_ALERT_PROPERTY built-in.
-
List the editors availables in forms 4.0?
-
What buil-in routines are used to display editor dynamicaly?
Edit_text item show_editor LOV
g_sidhu
- Feb 14th, 2008
A user-named editor can be displayed programmatically with the built-in procedure SHOW_EDITOR, independent of any particular text item. By default, operators can invoke an editor by navigating to a te...
-
What is an Lov?
A list of values is a single or multi column selection list displayed ina pop-up window
g_sidhu
- Feb 14th, 2008
An LOV is a scrollable popup window that provides the end user with either a single or multi-column selection List.
abhishek
- Oct 7th, 2006
its is list of value it is dynamic or static list flexible and efficient..it takes data from record group n record group is based on data base ....structure.It is array of values.. we can have m...
-
Can you attach an lov to a field at design time?
Yes.
g_sidhu
- Feb 14th, 2008
Yes, In the Object Navigator, double-click the object icon beside the desired text item to display the Property Palette. Under the List of Values (LOV) node, set the LOV property by entering the name ...
-
Can you attach an lov to a field at run-time? if yes, give the build-in name.?
Yes. Set_item_proprety
g_sidhu
- Feb 14th, 2008
Yes, You can attach an LOV to a text item programmatically with the SET_ITEM_PROPERTY Built-in subprogram. The following example attaches the LOV called lov2 to the text item called emp.empno: Set_Ite...
-
What is the built-in used for showing lov at runtime?
Show_lov
g_sidhu
- Feb 14th, 2008
The SHOW_LOV built-in is also used to display LOVs, but its functionality is slightly different from that of LIST_VALUES. It does not require that the LOV be attached to an item and it allows you to c...
-
What is the built-in used to get and set lov properties during run-time?
Get_lov_property Set_lov_property Record Group
g_sidhu
- Feb 14th, 2008
/*** Built-in: SET_LOV_PROPERTY ** Example: if LOV is currently base on GROUP1, ** make LOV use GROUP2 */ DECLARE lov_id LOV; BEGIN lov_id := Find_LOV('My_LOV_1'); IF Get_LOV_Property(lov_id,GROUP_NAME) = 'GROUP1' THEN Set_LOV_Property(lov_id,GROUP_NAME,'GROUP2'); ENDIF; END;
g_sidhu
- Feb 14th, 2008
GET_LOV_PROPERTY: Returns information about a specified list of values (LOV). You must issue a call to the built-in once for each property value you want to retrieve. /*** Built-in: GET_LOV_PROPERTY *...
-
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
g_sidhu
- Feb 14th, 2008
All LOVs are based on another Forms object called a record group. Record groups are logical objects, so they have no physical properties and are never displayed to the user. A record group is si...
ra
- May 25th, 2007
A record group is an internal Form Builder data structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that be...
-
What is a library in Forms 4.0?
A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
g_sidhu
- Feb 14th, 2008
A library is a collection of subprograms, including user-named procedures, functions, and packages. Libraries provide a convenient means of storing client-side program units and sharing them among mul...
-
List some built-in routines used to manipulate images in image_item?
Image_add Image_and Image_subtract Image_xor Image_zoom
g_sidhu
- Feb 15th, 2008
Image_addImage_andImage_subtractImage_xorIMAGE_ZOOM: Zooms the image in or out using the effect specified in zoom_type and the amount specified in zoom_factor.IMAGE_SCROLL: Scrolls the image item as c...
-
What is a predefined exception available in forms 4.0?
Raise form_trigger_failure
g_sidhu
- Feb 15th, 2008
Raising the FORM_TRIGGER_FAILURE Exception: The FORM_TRIGGER_FAILURE exception is a predefined PL/SQL exception available only in Oracle Forms. Because it is predefined, you can raise this exception w...
-
What are the types of TRIGGERS ?
1. Navigational Triggers. 2. Transaction Triggers.
kishor s pawar
- Mar 17th, 2008
Pre triggers,post triggers,when trigger,transactional trigger,validation triggers,key triggerskishor
anilkln
- Feb 21st, 2008
actually there r 3 levels of triggers1)formlevel 2)block level 3) item leveland types of triggers r1 activex triggers2 block processing triggers3 interface event triggers4 key triggers5mas...
-
What are the built_in used to trapping errors in forms 4?
Error_type return character Error_code return number Error_text return char Dbms_error_code return no. Dbms_error_text return char
sandeep5580
- Mar 29th, 2008
Well i am not pretty sure about this. I think we can use sqlerrm to trap an error.Thanks.Sandeep
-
Can we use GO-BLOCK package in a pre-field trigger ?
No.
-
What are the triggers associated with master detail relationships ?
Ziaullah
- Jul 18th, 2008
NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details ISOLATEDa) on clear detailsb) on populate detailsCASCADE a) per-deleteb) on clear detailsc) on populate details
Neethi
- Jan 17th, 2007
* Non-Isolated (default)On-Check delete MasterOn Populate DetailsOn Clear Details*IsolatedOn Clear DetailsOn Populate Details*CascadePer-DeleteOn Clear detailsOn Populate Details
-
Can a value for a display item come from two blocks? How will that be done?
table12345
- Aug 1st, 2008
Yes it can come from two blocks. If the cource block is database/from clause?query?block then just go to the POST-QUERY of that block where display item exist and write :block.display_item:=block1.field1||block.field2 int hat POST-QUERY.
-
System _Generate Number
how can you generate the system _generate number in forms automaticallyhint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT CREATING SEQUNENCE
usmanahmad
- Aug 18th, 2008
1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long 2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids ...
-
What are the different types of key triggers ?
Function Key Key-function Key-others Key-startup
Oracle Forms Interview Questions
Ans