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

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

1 Answer

Answer :

get_lov_property
set_lov_property
by

Related questions

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

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)

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

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

What are the Built-ins to display the user-named editor?

Description : What are the Built-ins to display the user-named editor?

Last Answer : A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

What are the built -ins used for Modifying a groups structure?

Description : What are the built -ins used for Modifying a groups structure?

Last Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

What are the built-ins used for Creating and deleting groups?

Description : What are the built-ins used for Creating and deleting groups?

Last Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

What are the built-ins used for finding Object ID function?

Description : What are the built-ins used for finding Object ID function?

Last Answer : FIND_GROUP(function) FIND_COLUMN(function)

What are the built-ins used for finding object ID functions?

Description : What are the built-ins used for finding object ID functions?

Last Answer : Find_group(function) Find_column(function)

What are built-ins associated with timers?

Description : What are built-ins associated with timers?

Last Answer : find_timercreate_timerdelete_timer

What are the built-ins used for Getting cell values?

Description : What are the built-ins used for Getting cell values?

Last Answer : GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)

What are built-ins used for Processing rows?

Description : What are built-ins used for Processing rows?

Last Answer : GET_GROUP_ROW_COUNT(function) GET_GROUP_SELECTION_COUNT(function) GET_GROUP_SELECTION(function) RESET_GROUP_SELECTION(procedure) SET_GROUP_SELECTION(procedure) UNSET_GROUP_SELECTION(procedure)

What are the built-ins used for processing rows?

Description : What are the built-ins used for processing rows?

Last Answer : Get_group_row_count(function) Get_group_selection_count(function) Get_group_selection(function) Reset_group_selection(procedure) Set_group_selection(procedure) Unset_group_selection(procedure)

What are the Built-ins used for sending Parameters to forms?

Description : What are the Built-ins used for sending Parameters to forms?

Last Answer : You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

What is the difference between static and dynamic lov

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

How do you use the same lov for 2 columns

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

What are the built_ins used the display the LOV?

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

Last Answer : Show_lov List_values

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

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

Last Answer : Yes

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

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

What is an LOV?

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.

What are the difference between lov & list item?

Description : What are the difference between lov & list item?

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

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

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

Last Answer : Record Group.

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

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.

What built-in is used for changing the properties of the window dynamically?

Description : What built-in is used for changing the properties of the window dynamically?

Last Answer : Set_window_property Canvas-View

Explain the use of setting GLOBAL_NAMES equal to TRUE.

Description : Explain the use of setting GLOBAL_NAMES equal to TRUE.

Last Answer : Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.

What is path setting for DLL?

Description : What is path setting for DLL?

Last Answer : Make sure you include the name of the DLL in the FORMS45_USEREXIT variable of the ORACLE.INI file, or rename the DLL to F45XTB.DLL. If you rename the DLL to F45XTB.DLL, replace the existing F45XTB.DLL in the ORAWINBIN directory with the new F45XTB.DLL.

What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

What is COMPRESS and CONSISTENT setting in EXPORT utility?

Description : What is COMPRESS and CONSISTENT setting in EXPORT utility?

Last Answer : COMPRESS Simply: COMPRESS=n - Allocated space in database for imported table will be exactly as the space required to hold the data. COMPRESS=y - The INITIAL extent of the table would be ... . To minimize this possibility, export those tables at a time when updates are not being done.

What is Automatic Management of Segment Space setting?

Description : What is Automatic Management of Segment Space setting?

Last Answer : Oracle9i New Feature Series: Automatic Segment Space Management Automatic Segment Space Management (ASSM) introduced in Oracle9i is an easier way of managing space in a segment using bitmaps. It ... . ASSM can be specified only with the locally managed tablespaces (LMT). Oracle uses bitmaps

What is PCTFREE and PCTUSED Setting?

Description : What is PCTFREE and PCTUSED Setting?

Last Answer : PCTFREE is a block storage parameter used to specify how much space should be left in a database block for future updates. For example, for PCTFREE=10, Oracle will keep on adding new rows to a block ... SQL> SELECT pct_free FROM user_tables WHERE table_name = 'EMP'; PCT_FREE ---------- 10

What is PCT Increase setting?

Description : What is PCT Increase setting?

Last Answer : PCTINCREASE refers to the percentage by which each next extent (beginning with the third extend) will grow. The size of each subsequent extent is equal to the size of the previous extent plus this ... /O may be required to fetch the additional blocks where extent maps of the segment are stored.

What does invoke built-in do?

Description : What does invoke built-in do?

Last Answer : This procedure invokes a method. Syntax: PROCEDURE OLE2.INVOKE (object obj_type, method VARCHAR2, list list_type := 0); Parameters: object Is an OLE2 Automation Object. method Is a method (procedure) ... OLE2 object. list Is the name of an argument list assigned to the OLE2.CREATE_ARGLIST function.

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

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

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

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

Give built-in routine related to a record groups?

Description : Give built-in routine related to a record groups?

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

What is the built-in function used for finding the alert?

Description : What is the built-in function used for finding the alert?

Last Answer : Find_alert Editors

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

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

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

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

What is the built-in routine used to count the no of rows in a group?

Description : What is the built-in routine used to count the no of rows in a group?

Last Answer : Get_group _row_count System Variables

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

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

What built-in is used for showing the alert during run- time?

Description : What built-in is used for showing the alert during run-time?

Last Answer : Show_alert.

What are the built-in used for getting cell values?

Description : What are the built-in used for getting cell values?

Last Answer : Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)

What is the use of image_zoom built-in?

Description : What is the use of image_zoom built-in?

Last Answer : To manipulate images in image items.

What is new_form built-in?

Description : What is new_form built-in?

Last Answer : When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second ... the first form, the operator will be prompted to save them before the new form is loaded.

Can you built indexes online?

Description : Can you built indexes online?

Last Answer : YES. You can create and rebuild indexes online. This enables you to update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the ... online index build operations: CREATE INDEX emp_name ON emp (mgr, emp1, emp2, emp3) ONLINE;

What are savepoint mode and cursor mode properties ? level?

Description : What are savepoint mode and cursor mode properties ? level?

Last Answer : Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE data sources. For applications that will run ... use the default setting. Cursor mode - define cursur state across transaction Open/close.

what are key-mode and locking mode properties? level ?

Description : what are key-mode and locking mode properties? level ?

Last Answer : Key Mode : Specifies how oracle forms uniquely identifies rows in the database.This is property includes for application that will run against NON-ORACLE datasources . Key setting unique (default.) ... locks on rows that correspond to queried records in the form. a) immediate b) delayed

What are the Various Block Coordination Properties

Description : What are the Various Block Coordination Properties

Last Answer : The various Block Coordination Properties are a) Immediate Default Setting. The Detail records are shown when the Master Record are shown. b) Deffered with Auto Query Oracle Forms defer fetching the ... No Auto Query The operator must navigate to the detail block and explicitly execute a query

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

What are the Coordination Properties in a Master-Detail relationship?

Description : What are the Coordination Properties in a Master-Detail relationship?

Last Answer : The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur