How do you reference a parameter indirectly?

How do you reference a parameter indirectly?
by

1 Answer

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

Related questions

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

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.

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

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

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.

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.

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

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.

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

What are the different objects that you cannot copy or reference in object groups?

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

What is bind reference and how can it be created?

Description : What is bind reference and how can it be created?

Last Answer : Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

What is lexical reference? How can it be created?

Description : What is lexical reference? How can it be created?

Last Answer : Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.

What do you understand by Reference Data Sharing?

Description : What do you understand by Reference Data Sharing?

Last Answer : In oracle Fusion Reference data sharing facilitates sharing of configuration data such as jobs, grades across business units. It can be understood as buckets of reference data assigned to ... where appropriate. In Oracle Fusion Applications reference data sharing feature is also known as SetID

What is a reference parameter?

Description : What is a reference parameter? 

Last Answer : Reference parameters reference the original object whereas value parameters make a local copy and do not affect the original. Some example code is shown: using System; namespace Console1 { class Class1 { ... public string TestValue; } The output for this is: 2 1 New value New value

Automatic initialization of object is carried out using a special member function called ………… A) Friend B) Casting C) Reference Parameter D) Constructor

Description : Automatic initialization of object is carried out using a special member function called ………… A) Friend B) Casting C) Reference Parameter D) Constructor

Last Answer : D) Constructor

Do all religions indirectly attack each other?

Description : Do all religions indirectly attack each other?

Last Answer : answer:Why are you attacking all people of faith? Why should they argue with others of different faiths? They are secure in their own beliefs.

Can you imagine what it feels like to indirectly or accidently cause permanent damage to another human being?

Description : Can you imagine what it feels like to indirectly or accidently cause permanent damage to another human being?

Last Answer : Could have been worse, it could have been something he could have avoided by being more careful. It’s a whole lot more difficult to forgive yourself for that.

Is it possible to live healthily on a diet that is not directly or indirectly connected to the harm of living beings?

Description : Is it possible to live healthily on a diet that is not directly or indirectly connected to the harm of living beings?

Last Answer : Many plants make their seeds and die. So we can use all the seeds and use nuts. Root vegetables make themselves and die so we can use all root vegetables. Legumes also grow their seed pods ... pick some without killing the plant and all the cabbagy plants that die after they make their vegetable.

Even if among friends, how does joking about anything gay affect those directly or indirectly involved in the joke?

Description : Even if among friends, how does joking about anything gay affect those directly or indirectly involved in the joke?

Last Answer : It really depends on the intent behind the joke - mean spirited or bigoted comments are usually very recognizable. Otherwise, I'm just a guilty as the next person for joking about stereotypes. It's definitely ... continue in the same vein, then that's not someone that I'm going to hang out with.

In Hurston's Sweat white culture is portrayed only indirectly and is represented in Delia's .?

Description : In Hurston's Sweat white culture is portrayed only indirectly and is represented in Delia's .?

Last Answer : laundry

What group is targeted negatively but indirectly by swift in and ldquo A modest proposal?

Description : What group is targeted negatively but indirectly by swift in and ldquo A modest proposal?

Last Answer : Feel Free to Answer

What one factor distinguishes reports developed directly from those developed indirectly?

Description : What one factor distinguishes reports developed directly from those developed indirectly?

Last Answer : What is the answer ?

What group is targeted negatively but indirectly by swift in a modest proposal (apex)?

Description : What group is targeted negatively but indirectly by swift in a modest proposal (apex)?

Last Answer : upper-class families of Ireland - apex

What group is targeted negatively but indirectly by swift in a model proposal?

Description : What group is targeted negatively but indirectly by swift in a model proposal?

Last Answer : What is the answer ?

What scale do seismologists use to indirectly measure the magnitude of an earthquake?

Description : What scale do seismologists use to indirectly measure the magnitude of an earthquake?

Last Answer : What is the answer ?

Will not be directly or indirectly involved means?

Description : Will not be directly or indirectly involved means?

Last Answer : Need answer

How do living things get energy indirectly?

Description : How do living things get energy indirectly?

Last Answer : By eating other living things.

Which of the following statements regarding the complement system are true? a. Complement activation yields products which are directly cytotoxic as well as products which act indirectly via activated leukocytes b. Complement products referred to as anaphylatoxins include C1, C3a, C4a, and C5a c. The principal role of C5a is in bacterial opsonization d. The alternative and classical pathways converge proximal to generating the membrane attack complex (C5b-9)

Description : Which of the following statements regarding the complement system are true? a. Complement activation yields products which are directly cytotoxic as well as products which act indirectly via activated ... and classical pathways converge proximal to generating the membrane attack complex (C5b-9)

Last Answer : Answer: a, d The complement system is composed of two different but linked sequences, the classic and alternative pathways. The pathways involve serum proteins that act to amplify the inflammatory-immune ... the C5 level proximal to generating the membrane attack complex (C5b-9) (Figure 6-3)

The members of the Panchayat Samiti are - (1) nominated by the Block Development officer (2) nominated by the Zila Panchayat Chairman (3) directly elected by the people (4) indirectly electred by the members of the Village Panchayat

Description : The members of the Panchayat Samiti are - (1) nominated by the Block Development officer (2) nominated by the Zila Panchayat Chairman (3) directly elected by the people (4) indirectly electred by the members of the Village Panchayat

Last Answer : (3) directly elected by the people Explanation: The voters of the State Legislative Assembly of the region directly elect members of the Panchayat Samiti. All the Pradhans of the Gram Panchayat within ... of the Rajya Sabha residing in that block-all are ex-officio members of the Panchayat Samiti.

The members of the Legislative Assembly are – (1) indirectly elected (2) directly elected by the people (3) partly elected and partly nominated by the Governor (4) mainly nominated

Description : The members of the Legislative Assembly are – (1) indirectly elected (2) directly elected by the people (3) partly elected and partly nominated by the Governor (4) mainly nominated

Last Answer : (2) directly elected by the people Explanation: Members of a Legislative Assembly (Vidhan Sabha) are direct representatives of the people of the particular state as they are directly elected by an electorate ... outlined in the Constitution of India is not more than 500 members and not less than 60.

Which one of the following statements reflects the republic character of Indian democracy? (1) Written Constitution (2) No State religion (3) Devolution of power to local Government institutions (4) Elected President and directly or indirectly elected Parliament

Description : Which one of the following statements reflects the republic character of Indian democracy? (1) Written Constitution (2) No State religion (3) Devolution of power to local Government institutions (4) Elected President and directly or indirectly elected Parliament

Last Answer : (4) Elected President and directly or indirectly elected Parliament Explanation: Democracy is a system of government that allows the citizens to cast vote and elect a government of their choice. ... citizens the right to vote irrespective of their caste, colour, creed, religion and gender.

A ‘republic’ is a state in which the Head of the State is - (1) nominated by the Prime Minister. (2) elected, directly or indirectly, by the people. (3) selected by the ruling party. (4) self-appointed.

Description : A ‘republic’ is a state in which the Head of the State is - (1) nominated by the Prime Minister. (2) elected, directly or indirectly, by the people. (3) selected by the ruling party. (4) self-appointed.

Last Answer : (2) elected, directly or indirectly, by the people Explanation: A ‘republic’ is a state in which the head of the State is directly or indirectly or appointed by the people. Currently, 135 of their official names.

Conductor resistance may be INDIRECTLY measured by using a/an _____________. A. voltmeter only B. ammeter only C. voltmeter and an ammeter D. ohmmeter only

Description : Conductor resistance may be INDIRECTLY measured by using a/an _____________. A. voltmeter only B. ammeter only C. voltmeter and an ammeter D. ohmmeter only

Last Answer : Answer: C

Appropriate government means in relation to a public authority which is established, constituted, owned, controlled or substantially financed by funds provided directly or indirectly by a) The Central government b) The State government c) Union territory administration d) All the above

Description : Appropriate government means in relation to a public authority which is  established, constituted, owned, controlled or substantially financed by funds provided  directly or indirectly by a) The Central government b) The State government c) Union territory administration d) All the above

Last Answer : d) All the above