-
What are static and dynamic reports?
What are static and dynamic reports in oracle and where do we use them?
-
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
-
How do you control the constraints in forms ?
Select the use constraint property is ON Block definition screen. BLOCK
i.govardhan
- Sep 18th, 2008
We control the constraints in forms while selecting primary key 'yes' in property palett.
parash_3380
- May 4th, 2006
Hi,we control the constraints in forms while selecting primary key 'YES' in property palette.
-
What is Post-Block is a . a. Navigational Trigger. b. Key trigger c. Transaction Trigger. Navigational Trigger.
mukts
- Mar 31st, 2006
Navigational Trigger.
-
What are the triggers associated with a check box?
Only When-checkbox-activated Trigger associated with a Check box.
ashly
- Apr 18th, 2006
when_checkbox_changed
-
What is a display item?
Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.
g_sidhu
- Feb 13th, 2008
Display items and text items are fairly similar and share many of the same properties. The biggest difference between the two is that a user can navigate to a text item and change its value. This is not possible with a display item. As its name implies, it merely displays information.
Sailaja Pasupuleti
- Dec 4th, 2005
Display items are non-input items. User cannot navigate into such type of item either with keyboard or mouse. For derived values user can use display item.
-
What is a list item?
It is a list of text elements.
g_sidhu
- Feb 13th, 2008
List items are exactly what their name implies—a short list of values that the user can choose from. List items can serve as either database or non-database items.They present the user with a nu...
Sailaja Pasupuleti
- Dec 4th, 2005
To understand list item, take MS-Word application. If user wants to change the text Font then user can choose/select a required Font from the available list (called list...
-
What are the display styles of list items?
Poplist, No text Item displayed in the list item. Tlist, No element in the list is highlighted.
g_sidhu
- Feb 13th, 2008
There are three types of list items: poplists, Tlists, and combo boxes. Poplists, which are the default type. They restrict the user from selecting only from the list elements that are displayed. A co...
-
What is a radio Group?
Radio groups display a fixed no of options that are mutually Exclusive .User can select one out of n number of options.
g_sidhu
- Feb 13th, 2008
Radio groups are logical containers of radio buttons. Radio buttons are the small circles that appear on the screen which the user can click to select values. Radio group selections are mutually exclusive. That is, selection of one radio button deselects the previously selected button.
-
How many maximum number of radio buttons can you assign to a radio group?
Unlimited no of radio buttons can be assigned to a radio group
g_sidhu
- Feb 13th, 2008
A good rule of thumb is to have no more than six radio buttons in a radio group. If there are going to be more than six, you might want to consider using a list item, which provides similar functional...
sri ganesh
- May 29th, 2006
hai, this answer is : Depending on Application. &nb...
-
What are the types of visual attribute settings?
Custom Visual attributes Default visual attributes Named Visual attributes. Window
g_sidhu
- Feb 13th, 2008
There are three values for the Visual Attribute Type property:1) Common, which for text and display items applies to the item itself and its prompt. Common visual attributes can also be used for other...
Shyamal Kumar
- Mar 18th, 2006
Visual attribute type are1.)Common2.)Prompt3.)Title
-
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...
-
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.
-
What is a window?
A window, by itself , can be thought of as an empty frame. The frame provides a way to interact with the window, including the ability to scroll, move, and resize the window. The content of the window i.e. what is displayed inside the frame is determined by the canvas View or canvas-views displayed...
g_sidhu
- Feb 13th, 2008
For a canvas and its items to be visible, it must be assigned to a window. By the same token, for a window to be visible, it must contain at least one canvas. Therefore, canvases and windows rely on e...
kusuma
- Feb 5th, 2007
A window is going to consider if it is having menimise button,maximise button,close button
-
List the editors availables in forms 4.0?
-
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...
-
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...
-
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...
-
Oracle Forms Interview Questions
Ans