-
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.
-
What is a Trigger ?
A piece of logic that is executed at or triggered by a SQL *forms event.
Bashartullakhan
- Aug 17th, 2011
Triggers are a special PL/SQL construct similar to procedures. However, a procedure is executed explicitly from another block via a procedure call, while a trigger is executed implicitly whenever the triggering event happens. The triggering event is either a INSERT, DELETE, or UPDATE command.
manishagoyal23
- Sep 4th, 2009
A forms trigger is a block of PL/SQL code that adds functionality to your application. Triggers are attached to objects in your application. When a trigger is fired, it executes the code it contai...
-
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...
-
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.
-
What is the difference between Property Pallete and Visual Attributes ?Also explain what is Object Group in Oracle Forms ?
santhisistla
- Jul 29th, 2010
Property pallete is used to apply changes to only that object item, as visual attributes are used in more generic manner. Visual attributes are used in the projects in which common specific...
kyuvarajbe
- Jun 11th, 2010
Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.
-
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.
younaskhan40
- Apr 20th, 2010
PRE-QUERY fire once when block goes in execute-query Mode.andPOST-QUERY fire=TOTAL NUMBER OF RECORDS RETRIEVED.in the above case POST-QUERY fires 10 times.
AShutosh Trivedi
- Jun 10th, 2006
Pre_Query fires onceAnd Post_Query fires for each record means in this condition it fires 10 times.
-
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
-
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?
imranbaig.geek
- Mar 25th, 2010
Text_IO Package in Oracle reports 10g Procedure/Exception/Function DescriptionTEXT_IO.FCLOSE procedure that closes an open file.TEXT_IO.FILE_TYPE type that specifies a h...
-
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...
-
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)
imranbaig.geek
- Mar 25th, 2010
Record group triggersGET_GROUP_SELECTION Built-inGET_GROUP_SELECTION_COUNT Built-inGET_GROUP_ROW_COUNT Built-inGET_GROUP_RECORD_NUMBER Built-inSET_GROUP_CHAR_CELL Built-inSET_GROUP_number_CELL Built-i...
-
What are the different types of windows?
Root window, secondary window.
g_sidhu
- Feb 13th, 2008
There are two styles of windows in Forms: document and dialog. Document windows are commonly used for data entry and query screens; they are the main windows in an application. Dialog windows are used...
-
What are the types of canvas-views?
Content View, Stacked View.
manish
- Sep 17th, 2006
Conetent View(Default)Stack View(Only create on content canvas only)Tab ViewToolbar View(Vertical/Horizontal)--Always try to connect it with window for many forms in one application.
-
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
imranbaig.geek
- Mar 25th, 2010
Parameter list built-ins in Forms 10g ADD_PARAMETER CREATE_PARAMETER_LIST DELETE_PARAMETERDESTROY_PARAMETER_LISTGET_PARAMETER_ATTRID_NULLRUN_PRODUCTSET_PARAMETER_ATTR RegardsImran Baig
g_sidhu
- Feb 15th, 2008
GET_PARAMETER_LISTDESTROY_PARAMETER_LISTCREATE_PARAMETER_LISTADD_PARAMETERDelete_parameterADD_LIST_ELEMENT(item, index, label, value) SET_PARAMETER_ATTR(List, key, paramtype, value) for a Date parameter defined at design timeGet_parameter_attr
-
Can a sigle canvas be used by different blocks ?
-
If the same trigger is present in Form, Block and Item level, normally the item level will fire first. How to change this default one. That is I want to fire the block level or form level. How to do this?
imranbaig.geek
- Mar 25th, 2010
If same trigger is fired at form block, item item gets executed first then block then form. To change the process, change the trigger property execution hierarchy to "after" from "overridden".RegardsImran Baig
dj_dj_dj
- Jul 1st, 2009
No Idea ?If anybody know it kindly let me also know the right answer.RegardsDharmendra JaiswalCMS.
-
How to find out duplicate records ?
swetashashi
- Feb 10th, 2010
SELECT emp_name,count(emp_name) AS cntFROM employeeGROUP BY emp_nameWHERE cnt>1
vara
- Nov 18th, 2007
Select * from emp a where rowid >(select min(rowid) from emp b where a.empno = b.empno)
-
How can you call a form on a form
muniyuga
- Oct 24th, 2009
The communication between forms can be done in the following 3 wayslet say Form A calls FormB1.Using New_Form: this Terminates Form A and activates Form BThe NewForm will terminates your current activ...
sumanpani
- Sep 16th, 2008
By using Gobal Variable we can call ?Form to Form?Form to Report?Form to Graph
-
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...
-
Is it possible to attach same library to more than one form?
Yes
-
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 ...
Oracle Forms Interview Questions
Ans