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

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

1 Answer

Answer :

Add_parameter
Create_Parameter_list
Delete_parameter
Destroy_parameter_list
Get_parameter_attr
Get_parameter_list
set_parameter_attr
by

Related questions

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

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

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

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

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

List the windows event triggers available in Forms 4.0?

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

What buil-in routines are used to display editor dynamicaly?

Description : What buil-in routines are used to display editor dynamicaly?

Last Answer : Edit_text item show_editor LOV

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.

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

What are the design facilities available in forms 4.0?

Description : What are the design facilities available in forms 4.0?

Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.

What is a predefined exception available in forms 4.0?

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

List the editors availables in forms 4.0?

Description : List the editors availables in forms 4.0?

Last Answer : Default editor User_defined editors system editors.

What is the OPTIMAL parameter?

Description : What is the OPTIMAL parameter?

Last Answer : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

What are the minimum parameters should exist in the parameter file (init.ora) ?

Description : What are the minimum parameters should exist in the parameter file (init.ora) ?

Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

What are the values that can be specified for OPTIMIZER MODE Parameter ?

Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?

Last Answer : COST and RULE.

s it possible to disable the parameter from while running the report?

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

Can u run the report with out a parameter form

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

What is difference between a formal and an actual parameter?

Description : What is difference between a formal and an actual parameter?

Last Answer : The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are ... procedure and receive results. Formal parameters are the placeholders for the values of actual parameters

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

How do you reference a Parameter?

Description : How do you reference a Parameter?

Last Answer : In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name

What use of command line parameter cmd file?

Description : What use of command line parameter cmd file?

Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

Which parameter can be used to set read level consistency across multiple queries?

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

What are the different Parameter types?

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

What is the maximum no of chars the parameter can store?

Description : What is the maximum no of chars the parameter can store?

Last Answer : The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

How do you reference a parameter indirectly?

Description : How do you reference a parameter indirectly?

Last Answer : To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')

When do you use data parameter type?

Description : When do you use data parameter type?

Last Answer : When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogra

Does a Before form trigger fire when the parameter form is suppressed?

Description : Does a Before form trigger fire when the parameter form is suppressed?

Last Answer : Yes.

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 PGA_AGGREGATE_TARGET parameter?

Description : What is PGA_AGGREGATE_TARGET parameter?

Last Answer : PGA_AGGREGATE_TARGET: specifies the target aggregate PGA memory available to all server processes attached to the instance.

What parameter will you use to force the starting of your database with a corrupted resetlog?

Description : What parameter will you use to force the starting of your database with a corrupted resetlog?

Last Answer : ALLOW_RESETLOGS_CORRUPTION

How can you difference a usual parameter and an undocumented parameter?

Description : How can you difference a usual parameter and an undocumented parameter?

Last Answer : Undocumented parameters have the prefix ‘_’. For example, _allow_resetlogs_corruption

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

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

How image_items can be populate to field in forms 4.0?

Description : How image_items can be populate to field in forms 4.0?

Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

What is a library in Forms 4.0?

Description : What is a library in Forms 4.0?

Last Answer : A library is a collection of Pl/SQL program units, including user named procedures, functions & packages

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

What are the menu items that oracle forms 4.0 supports?

Description : What are the menu items that oracle forms 4.0 supports?

Last Answer : Plain, Check,Radio, Separator, Magic

What is the significance of PAGE 0 in forms 3.0 ?

Description : What is the significance of PAGE 0 in forms 3.0 ?

Last Answer : Hide the fields for internal calculation.

How do you trap the error in forms 3.0 ?

Description : How do you trap the error in forms 3.0 ?

Last Answer : using On-Message or On-Error triggers.

Can we create two blocks with the same name in form 3.0 ?

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

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

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

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

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