-
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...
-
List system variables available in forms 4.0, and not available in forms 3.0?
System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working
imranbaig.geek
- Mar 25th, 2010
System Variable in forms 10gSYSTEM.BLOCK_STATUS SYSTEM.COORDINATION_OPERATION SYSTEM.CURRENT_BLOCK SYSTEM.CURRENT_DATETIME SYSTEM.CURRENT_FORM SYSTEM.CURRENT_ITEM SYSTEM.CURRENT_VALUE SYSTEM.CURSOR_BL...
-
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 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
-
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 is folder form?
Definitions, Usage and its Information in Oracle forms 9i
Lokesh M
- Dec 8th, 2011
Oracle Applications - Folder Functionality are made use of in custom forms. Folder Functionality enables user to perform host of actions on fields such as ordering, renaming, resizing, moving, including, excluding etc., in a multi-row block.
-
Report 6i Object Anchoring
What do you mean by anchoring on object?
samareshp
- Apr 20th, 2009
Anchors fasten an edge of one object to an edge of another object, ensuring that they maintain their relative positions. For example, you can anchor boilerplate text to the edge of a variable-sized re...
-
How will you post two independent transactions in forms 6i
asifinet
- Feb 16th, 2013
Declare the PRAGMA AUTONOMUS_TRANSACTION; in Procedure,Package,Function/Anonymous Block etc.
-
What are dynamic reports? How will you create them
asifinet
- Feb 16th, 2013
Dynamic Reports are the Reports which is based on the GLOBAL_TEMPORARY TABLE. can be used in BEFORE RUN REPORT Trigger to populate the Data into that table by calling function/procedure. After report ...
-
Can we use program unit in a display field to create a formula calculated item?
-
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.
-
How will you create a formula or a summary column and refer it other fields
renukuntanagaraj
- Sep 10th, 2008
1. Open data model editor, increase the height of the group to make place for the formula column or summary column.2. Select the formula column tool button in the tool palette and place it after the l...
-
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 ...
-
Using data source as procedure.
Why do we use data source as procedure in Oracle forms? What is the use of taking procedure as Data Source?
rvnambiar
- Nov 30th, 2008
To increase the control and securityTo specify a Query at runtime, Eg: in case of manager logs in he can see more info wherein if its employee he will be able to see less dataIf you wanna specify any ...
-
WebUtils
Actual I am uploading the excel sheet data in the customer system that must generate into server system and store that excel sheet data into the particular database table...Plz help me.....we r trying from so many days ... my task has been stop there
Oracle Forms Interview Questions
Ans