What are the difference between lov & list item?

1 Answer

Answer :

Lov is a property where as list item is an item. A list item can have only
one column, lov can have one or more columns.

Related questions

Description : What are the built-ins that are used to Attach an LOV programmatically to an item?

Last Answer : set_item_property get_item_property (by setting the LOV_NAME property)

Description : What is the "LOV of Validation" Property of an item? What is the use of it?

Last Answer : When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If ... the LOV and uses the text item value as the search criteria to automatically reduce the list.

Description : What is the difference between static and dynamic lov

Last Answer : The static lov contains the predetermined values while the dynamic lov contains values that come at run time

Description : How do you use the same lov for 2 columns

Last Answer : We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code

Description : What are the built_ins used the display the LOV?

Last Answer : Show_lov List_values

Description : What is the built-in used to get and set lov properties during run-time?

Last Answer : Get_lov_property Set_lov_property Record Group

Description : Can you attach an lov to a field at design time?

Last Answer : Yes

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

Description : What is an LOV?

Last Answer : An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

Description : What are the built-ins that are used for setting the LOV properties at runtime?

Last Answer : get_lov_property set_lov_property

Description : What is the basic data structure that is required for creating an LOV?

Last Answer : Record Group.

Description : What is a list item?

Last Answer : It is a list of text elements.

Description : what is a display item?

Last Answer : 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.

Description : If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Last Answer : Item level trigger fires , If item level trigger fires, property level trigger won't fire. Triggers at the lowest level are always given the first preference. The item level trigger fires first and then the block and then the Form level trigger.

Description : What are the types of triggers and how the sequence of firing in text item

Last Answer : Triggers can be classified as Key Triggers, Mouse Triggers ,Navigational Triggers. Key Triggers :: Key Triggers are fired as a result of Key action.e.g :: Key-next-field, Key-up,Key-Down Mouse Triggers :: Mouse ... :: a) pre - text b) when new item c) key-next d) when validate e) post text

Description : What is a Navigable item?

Last Answer : A navigable item is one that operators can navigate to with the keyboard during default navigation, or that Oracle forms can navigate to by executing a navigational built-in procedure.

Description : What are the triggers associated with the image item?

Last Answer : When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)

Description : With which function of summary item is the compute at options required?

Last Answer : ummary item is the compute at options required?

Description : What is difference between TRUNCATE & DELETE ?

Last Answer : TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

Description : Difference between an implicit & an explicit cursor.?

Last Answer : only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop. Explicit cursor is a cursor in which the cursor name is explicitly ... statements An implicit cursor is used to process INSERT, UPDATE, DELETE and single row SELECT. .INTO

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

Description : What is the difference between OLE Server & Ole Container?

Last Answer : An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate ... are created by ole server applications. Ex. oracle forms is an example of an ole Container.

Description : What is the difference between object embedding & linking in Oracle forms?

Last Answer : In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.

Description : How does one list one's databases in the OEM Console? (for DBA

Last Answer : Follow these steps to discover databases and other services from the OEM Console: 1. Ensure the GLOBAL_DBNAME parameter is set for all databases in your LISTENER.ORA file (optional). ... OEM Discovery Wizard will guide you through the process of discovering your databases and other services.

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Description : List the built-in routines for the controlling canvas views during run-time?

Last Answer : Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

Description : List the editors availables in forms 4.0?

Last Answer : Default editor User_defined editors system editors.

Description : List the built-in routine for controlling window during run-time?

Last Answer : Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

Description : List the built-in routine for controlling window during run-time?

Last Answer : Find_window, get_window_property, hide_window, move_window, resize_window, set_window_property, show_View

Description : List some built-in routines used to manipulate images in image_item?

Last Answer : Image_add Image_and Image_subtract Image_xor Image_zoom

Description : List system variables available in forms 4.0, and not available in forms 3.0?

Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

Description : List the Types of Items?

Last Answer : Text item. Chart item. Check box. Display item. Image item. List item. Radio Group. User Area item.

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

Description : List the system variables related in Block and Field?

Last Answer : 1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.

Description : Where can one get a list of all hidden Oracle parameters? (for DBA

Last Answer : Oracle initialization or INIT.ORA parameters with an underscore in front are hidden or unsupported parameters. One can get a list of all hidden parameters by executing this query: select * from SYS.X$KSPPI ... 1,1)='_' order by a.ksppinm; Remember: Thou shall not play with undocumented parameters!

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

Description : What are the two ways by which data can be generated for a parameters list of values?

Last Answer : 1. Using static values. 2. Writing select statement.

Description : What are the different display styles of list items?

Last Answer : Pop_listText_listCombo box

Description : What is pop list?

Last Answer : The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.

Description : What is a text list?

Last Answer : The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.

Description : VALUE SET LIST TYPES

Last Answer :  List of values (10 to 200)  Long list of values (> 200)  Poplist (> 10)

Description : Could you please list down some of common task used during implementation

Last Answer : Here are few basic and frequently used task 1. Manage Enterprise HCM Information 2. Manage Legal Entity HCM Information 3. Manage Legal Addresses 4. Manage Legal Entity 5. Manage Location ... Lookups 20. Manage Goal Management Notification Settings P.S. Task names are not case-sensitive

Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

Description : What is the frame & repeating frame?

Last Answer : A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.

Description : What is a physical page ? & What is a logical page ?

Last Answer : A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Last Answer : a) i& ii b) ii & iii