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

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

1 Answer

Answer :

1. Using static values.
2. Writing select statement.
by

Related questions

Can the default values be assigned to actual parameters?

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

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

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!

Can you pass data parameters to forms?

Description : Can you pass data parameters to forms?

Last Answer : No

Do user parameters appear in the data modal editor in 2.5?

Description : Do user parameters appear in the data modal editor in 2.5?

Last Answer : No

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 different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What are the modes of parameters that can be passed to a procedure ?

Description : What are the modes of parameters that can be passed to a procedure ?

Last Answer : IN,OUT,IN-OUT parameters.

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 are parameters?

Description : What are parameters?

Last Answer : Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

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 internal subroutine is called global data is used to pass values defining parameters between __ program and defined | a. Main and subroutine b. Local and subroutine c. Global and subroutine d. Global and main

Description : If internal subroutine is called global data is used to pass values defining parameters between __ program and defined | a. Main and subroutine b. Local and subroutine c. Global and subroutine d. Global and main

Last Answer : a. Main and subroutine

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

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.

Can you pass values to-and-fro from foreign function ? how ?

Description : Can you pass values to-and-fro from foreign function ? how ?

Last Answer : Yes . You obtain a return value from a foreign function by assigning the return value to an Oracle Forms variable or item. Make sure that the Oracle Forms variable or item is the same data type as ... SQL data type; it must also be the appropriate parameter type as defined in the PL/SQL interface.

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

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

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

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

CROSS VALIDATING VALUES

Description : CROSS VALIDATING VALUES

Last Answer : - For key flexfields with multiple segments, we can define rules to cross check value combinations entered with in the key flexfield segments. This option is referred as Cross Validation rules.

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

Which plant parameters shown in the illustration would produce an alarm if they exceeded preset values? EL-0094 A. SME #7 CYL. EXH. and L.O. TO RDCN. GR. B. L.O. PRESS. TO MN. ENG. and PME #3 MN. BRG. C. L.O. PRESS. TO MN. ENG. and L.O. TO RDCN. GR. D. PME #3 MN. BRG. and SME #7 CYL. EXH.

Description : Which plant parameters shown in the illustration would produce an alarm if they exceeded preset values? EL-0094 A. SME #7 CYL. EXH. and L.O. TO RDCN. GR. B. L.O. PRESS. TO MN. ENG. and PME #3 MN. BRG. C. L.O. PRESS. TO MN. ENG. and L.O. TO RDCN. GR. D. PME #3 MN. BRG. and SME #7 CYL. EXH.

Last Answer : Answer: D

Which plant parameters shown in the illustration would produce an alarm if they fell below preset values? EL-0094 A. SME #7 CYL. EXH. and L.O. PRESS. TO RDCN. GR. B. L.O. PRESS TO MN. ENG. and PME #3 MN. BRG. C. L.O. PRESS. TO MN. ENG and L.O. PRESS. TO RDCN. GR. D. PME #3 MN. BRG. and SME #7 CYL. EXH.

Description : Which plant parameters shown in the illustration would produce an alarm if they fell below preset values? EL-0094 A. SME #7 CYL. EXH. and L.O. PRESS. TO RDCN. GR. B. L.O. PRESS TO MN. ENG. and PME #3 MN. BRG. C. ... . TO MN. ENG and L.O. PRESS. TO RDCN. GR. D. PME #3 MN. BRG. and SME #7 CYL. EXH.

Last Answer : Answer: C

Define given parameters and state their values for bridge rectifier (i) Ripple factor (ii) PIV of diode.

Description : Define given parameters and state their values for bridge rectifier (i) Ripple factor (ii) PIV of diode.

Last Answer : Ripple Factor: Ripple Factor is defined as the ratio of RMS value of the AC component of output to the DC or average value of the output. Mathematically it is expressed as, ( ... which appears across non-conducting reverse biased diode. (ii) PIV of diode for bridge rectifier-Vm

When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, the function cannot change the original value in the array. (C) It results in compilation error when the function tries to access the elements in the array. (D) Results in a run time error when the function tries to access the elements in the array.

Description : When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, ... . (D) Results in a run time error when the function tries to access the elements in the array.

Last Answer : (A) The function can change values in the original array.

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

What are the ways to monitor the performance of the report?

Description : What are the ways to monitor the performance of the report?

Last Answer : Use reports profile executable statement. Use SQL trace facility.

A wholesaler sells printer cartridges. The minimum order quantity is 5. There is a 20% discount for orders of 100 or more printer cartridges. You have been asked to prepare test cases using various values for the number of printer cartridges ordered. Which of the following groups contain three test inputs that would be generated using Boundary Value Analysis? A. 5, 6, 20 B. 4, 5, 80C. 4, 5, 99 D. 1, 20, 100

Description : A wholesaler sells printer cartridges. The minimum order quantity is 5. There is a 20% discount for orders of 100 or more printer cartridges. You have been asked to prepare test cases using various values for the number of printer cartridges ... A. 5, 6, 20 B. 4, 5, 80C. 4, 5, 99 D. 1, 20, 100

Last Answer : C. 0, 1,10,11, 50, 51, 75, 76,100,101

In an experiment on studying the dependence of current flowing through a given resistor on the potential difference applied across it, list two ways how a student would change the values of current in the circuit?

Description : In an experiment on studying the dependence of current flowing through a given resistor on the potential difference applied across it, list two ways how a student would change the values of current in the circuit?

Last Answer : Answer. There are two ways in which a student can change the values of current in the circuit: By increasing or decreasing the number of cells. By changing the value of resistance.

Growth can be measured in various ways. Which of these can be used as parameters to measure growth?

Description : Growth can be measured in various ways. Which of these can be used as parameters to measure growth?

Last Answer : Growth can be measured in various ways. Which of these can be used as parameters to measure growth?

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

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.

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

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.

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

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 is a list item?

Description : What is a list item?

Last Answer : It is a list of text elements.

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 Types of Items?

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.

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

List the system variables related in Block and Field?

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.

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

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.

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 are the different display styles of list items?

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

Last Answer : Pop_listText_listCombo box

What is pop list?

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.

What is a text list?

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.

VALUE SET LIST TYPES

Description : VALUE SET LIST TYPES

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

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

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

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.