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

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

1 Answer

Answer :

Undocumented parameters have the prefix ‘_’. For example, _allow_resetlogs_corruption
by

Related questions

Are there any undocumented commands in Oracle? (for DBA

Description : Are there any undocumented commands in Oracle? (for DBA

Last Answer : Sure there are, but it is hard to find them. Look at these examples: From Server Manager (Oracle7.3 and above): ORADEBUG HELP It looks like one can change memory locations with the ORADEBUG POKE ... rdbms/lib/oradbx.o; make -f oracle.mk oradbx) SQL*Plus: ALTER SESSION SET CURRENT_SCHEMA = SYS;

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

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

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 many undocumented immigrants live in the US?

Description : How many undocumented immigrants live in the US?

Last Answer : crazyguy: “the number of “undocumented immigrants” (I believe that is the woke terminology for illegal aliens)” Why would anyone entertain this “question” after this ^ horseshit?

Would Americans do the jobs that undocumented workers do now?

Description : Would Americans do the jobs that undocumented workers do now?

Last Answer : Possibly in urban areas, but in agricultural areas - many place in the Midwest, as well as California, Alabama, Georgia - Americans have not opted to fill the jobs usually done by undocumented workers. ... bottom line is that the undocumented do play a role in the US economy and our food supply.

Would Rick Santorum be in favor of undocumented aliens carrying guns?

Description : Would Rick Santorum be in favor of undocumented aliens carrying guns?

Last Answer : There have been instances already, where the good guy with a gun (black, coincidentally'), was gunned down by the cops when they showed up. Apart from the obvious fact that the arriving coppers ... revealed that they are, as usual, full of shit, the propaganda damage will have already been done.

Why don't undocumented aliens just get the documents they need?

Description : Why don't undocumented aliens just get the documents they need?

Last Answer : P-ha! Been to dmv lately? C'mon, ypu're asking a question which involves the whole wide world. Look, for those who are legal, just, honest persons, there is a lot of paperwork, and even more ... worst squirmies will go. OMG, @tinyfaery , I can't believe we were both thinking dmv at the same time.

Should undocumented immigrants be enslaved?

Description : Should undocumented immigrants be enslaved?

Last Answer : answer:We should at least have some compassion and place them in prison first so they will get room and board. And it will work out great. Companies will get labor for pennies on the dollar while the ... scanners for around 80 cents a hour. A pack of top ramen was a dollar at the canteen.

What do you think of NYC, among other cities, issuing municipal IDs to undocumented immigrants so they can work, rent a place to live, etc.?

Description : What do you think of NYC, among other cities, issuing municipal IDs to undocumented immigrants so they can work, rent a place to live, etc.?

Last Answer : As long as they don’t wear their pajamas to the grocery store, I’m fine with it.

What do you make of the undocumented immigrants being flown into San Diego?

Description : What do you make of the undocumented immigrants being flown into San Diego?

Last Answer : answer:I lived in S.D. for years when I was younger and will never forget the all night Robertos, ( Humbertos, Jillbertos, Adalbertos, haha ) across the street from my apartment. BEST freaking ... citizens. I don't know enough about all the immigration ins & outs to know about obtaining Visas.

Unaccompanied children are crossing the US southern border in record numbers. Is this a US immigration crisis, making them undocumented immigrants, or is this a bigger international humanitarian crisis, making these kids refugees?

Description : Unaccompanied children are crossing the US southern border in record numbers. Is this a US immigration crisis, making them undocumented immigrants, or is this a bigger international humanitarian crisis, making these kids refugees?

Last Answer : answer:They expect 90,000 in the 2014 fiscal year. That's a lot of people, in my opinion. According to the article, and common sense, word will spread and more will come. ... ?module=Search&mabReward=relbias%3As%2C%5B%22RI%3A8%22% I am not thrilled that we're going to be supporting all these people.

What do you think of this grant that's being made available to undocumented students?

Description : What do you think of this grant that's being made available to undocumented students?

Last Answer : I am not even sure how I feel about them getting in-state tution. I have very mixed feelings on the topic. I guess I actually support the grant more than I do the in-state tuition. Grants are ... students. But, in-state is based on the family having had paid into the tax system of the state.

How are undocumented workers helpful to the US?

Description : How are undocumented workers helpful to the US?

Last Answer : The obvious answer are those field workers. Most Americans would not perform such work. It is hard work, and there is no easy-to-get-to restroom. Another I see at work. When we have a telephone ... contractor, and they really hustle. They work so hard and so fast it makes ME tired to watch them.

If the US employment situation worsens, will it spur citizens to take jobs that undocumented workers are doing?

Description : If the US employment situation worsens, will it spur citizens to take jobs that undocumented workers are doing?

Last Answer : Nope. Unemployment has been bad for 2½ years now, and no one has. Crops went unpicked in Georgia when the state cracked down on undocumented farm workers. They had to get convicts to pick the crops.

What do these headlines suggest about undocumented immigrants civil liberties?

Description : What do these headlines suggest about undocumented immigrants civil liberties?

Last Answer : While courts have protected undocumented immigrants’ civil liberties, some argue that those protections are being ignored

How Most undocumented aliens enter the US by?

Description : How Most undocumented aliens enter the US by?

Last Answer : Need answer

Do undocumented immigrants get welfare in California?

Description : Do undocumented immigrants get welfare in California?

Last Answer : Need answer

Difference between SUBSTR and INSTR ?

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

What is the difference between DBFile Sequential and Scattered Reads?(for DBA

Description : What is the difference between DBFile Sequential and Scattered Reads?(for DBA

Last Answer : Both "db file sequential read" and "db file scattered read" events signify time waited for I/O read requests to complete. Time is reported in 100's of a second for Oracle 8i releases and below, ... v_$system_event b where a.event = 'db file sequential read' and b.event = 'db file scattered read';

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

What is the difference between NAME_IN and COPY ?

Description : What is the difference between NAME_IN and COPY ?

Last Answer : Copy is package procedure and writes values into a field. Name in is a package function and returns the contents of the variable to which you apply.

What is the difference between restoring and recovering? (for DBA

Description : What is the difference between restoring and recovering? (for DBA

Last Answer : Restoring involves copying backup files from secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location. Recovery is the process ... as SYSDBA Sql> RECOVER DATABASE UNTIL TIME '2001-03-06:16:00:00' USING BACKUP CONTROLFILE;

What is the difference between online and offline backups? (for DBA

Description : What is the difference between online and offline backups? (for DBA

Last Answer : A hot backup is a backup performed while the database is online and available for read/write. Except for Oracle exports, one can only do on- line backups when running in ARCHIVELOG mode. A cold backup is a backup performed while the database is off-line and unavailable to its users.

What is the difference between the SQL*Loader and IMPORT utilities?

Description : What is the difference between the SQL*Loader and IMPORT utilities?

Last Answer : These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL* ... from different data sources just so long as it conforms to ASCII formatted or delimited files.

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

Description : What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

Last Answer : A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Description : Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Last Answer : ORACLE_BASE is the root directory for oracle. ORACLE_HOME located beneath ORACLE_BASE is where the oracle products reside.