-
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
-
Explain types of Block in forms4.0?
Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block...
g_sidhu
- Feb 13th, 2008
Base-table blocks, as their name implies, are based on a database table or view and must contain at least one item that is based on a column in that database table or view. If you create a block based...
manikandan
- Dec 24th, 2006
1)Datablocks that is directly related to base tables thru stored proc or views and 2,control blocks not associated with base tables
-
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 built-in routine for controlling window during run-time?
Find_window, get_window_property, hide_window, move_window, resize_window, set_window_property, show_View
g_sidhu
- Feb 14th, 2008
Find_window,get_window_property,hide_window,move_window,resize_window,set_window_property,show_Window
-
What is a canvas-view?
A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assigned to a specific canvas. ...
g_sidhu
- Feb 14th, 2008
CANVAS VIEWPORTS (VIEWS)The terms “canvas view” and “viewport” are synonymous. The viewport refers to the area of the canvas that is visible to the user. What this means is tha...
-
What is an Alert?
An alert is a modal window that displays a message notifies the operator of some application condition
g_sidhu
- Feb 14th, 2008
Alerts are windows that contain messages and buttons. They provide a convenient way to send a message to “alert” the user that something has caused an error, something they have done will have certain consequences, or that something has happened that they should simply know about.
-
What are the display styles of an alert?
Stop, Caution, note
g_sidhu
- Feb 14th, 2008
The three alert styles, Stop, Caution, and Note, let you communicate the urgency of an alert’s message to the user. Stop alerts should be used for the most urgent messages. Caution alerts can be...
-
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...
Oracle Forms Interview Questions
Ans