What ERASE package procedure does ?

What ERASE package procedure does ?
by

1 Answer

Answer :

Erase removes an indicated global variable.
by

Related questions

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 package procedure is used for calling another form ?

Description : What package procedure is used for calling another form ?

Last Answer : Call (E.g. Call(formname)

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.

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Description : What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Last Answer : A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What is a Package Procedure ?

Description : What is a Package Procedure ?

Last Answer : A Package procedure is built in PL/SQL procedure.

What Enter package procedure does ?

Description : What Enter package procedure does ?

Last Answer : Enter Validate-data in the current validation unit.

What package procedure used for invoke sql *plus from sql *forms ?

Description : What package procedure used for invoke sql *plus from sql *forms ?

Last Answer : Host (E.g. Host (sqlplus))

Can we use a restricted package procedure in ON- VALIDATE-FIELD Trigger ?

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

What the PAUSE package procedure does ?

Description : What the PAUSE package procedure does ?

Last Answer : Pause suspends processing until the operator presses a function key

What is the difference between restricted and unrestricted package procedure ?

Description : What is the difference between restricted and unrestricted package procedure ?

Last Answer : Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.

EXIT_FORM is a restricted package procedure ?a. True b. False

Description : EXIT_FORM is a restricted package procedure ?a. True b. False

Last Answer : True

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?

Last Answer : SHOW ERRORS

What is a Package ?

Description : What is a Package ?

Last Answer : A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.

What are the advantages of having a Package ?

Description : What are the advantages of having a Package ?

Last Answer : Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

What are two parts of package ?

Description : What are two parts of package ?

Last Answer : The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema. Package Body contains actual procedures and local declaration of the procedures and cursor declarations.

Identify package function from the following ?

Description : Identify package function from the following ?

Last Answer : 1. Error- Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code? 1. Error_Code 2. Error_Text 3. Form_Failure 4. Form_Fatal 5. Message_Code

Error_Code is a package proecdure ?

Description : Error_Code is a package proecdure ?

Last Answer : a. True b. false False

Can we use GO-BLOCK package in a pre-field trigger ?

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

What is a Text_io Package?

Description : What is a Text_io Package?

Last Answer : It allows you to read and write information to a file in the file system.

What does DBMS_FGA package do?

Description : What does DBMS_FGA package do?

Last Answer : The DBMS_FGA package provides fine-grained security functions. DBMS_FGA is a PL/SQL package used to define Fine Grain Auditing on objects. DBMS_FGA Package Subprograms: ▪ ADD_POLICY Procedure - ... DROP_POLICY Procedure - Drops an audit policy ▪ ENABLE_POLICY Procedure - Enables an audit policy

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

What are Procedure,functions and Packages

Description : What are Procedure,functions and Packages

Last Answer : Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not ... Provide a method of encapsulating and storing related procedures, functions, variables and other Package Contents

Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE

What is syntax for dropping a procedure and a function .Are these operations possible?

Description : What is syntax for dropping a procedure and a function .Are these operations possible?

Last Answer : Drop Procedure procedure_name Drop Function function_name

Difference between procedure and function.?

Description : Difference between procedure and function.?

Last Answer : Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

What is a Procedure ?

Description : What is a Procedure ?

Last Answer : A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.

What is difference between a PROCEDURE & FUNCTION ?

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

What is a stored procedure ?

Description : What is a stored procedure ?

Last Answer : A stored procedure is a sequence of statements that perform specific function.

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.

Give the structure of the procedure ?

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

Classify the restricted and unrestricted procedure from the following.

Description : Classify the restricted and unrestricted procedure from the following.

Last Answer : a. Call b. User-Exit c. Call-Query d. Up e. Execute-Query f. Message g. Exit-From h. Post i. Break? a. Call - unrestricted b. User Exit - Unrestricted c. Call_query - Unrestricted ... Query - Restricted f. Message - Restricted g. Exit_form - Restricted h. Post - Restricted i. Break - Unrestricted.

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Last Answer : False

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

What are the constructs of a procedure, function or a package ?

Description : What are the constructs of a procedure, function or a package ?

Last Answer : The constructs of a procedure, function or a package are : variables and constants cursors exceptions

Can I use a water-soluble marker on a dry erase board?

Description : Can I use a water-soluble marker on a dry erase board?

Last Answer : Are you talking about simple, washable markers?

If you can push a button to erase Twitter as if it never existed at all, would you do it?

Description : If you can push a button to erase Twitter as if it never existed at all, would you do it?

Last Answer : Does the button also cause Twitter never to exist in the future?

Ammonia based cremes erase itching. Can pee be used just as effectively?

Description : Ammonia based cremes erase itching. Can pee be used just as effectively?

Last Answer : If it was a wild animal that bit you, you should be more concerned and opt for medical attention and a series of rabies shots…if it was your S/O that bit you I would rub some dirt on it and take them out to dinner more often.

Can I erase the fraud claim on me?

Description : Can I erase the fraud claim on me?

Last Answer : Whether proven or not you were investigated for fraud. That's a simple fact and it's relevant information for any financial institution to consider before hiring you. I doubt there's anything you can do ... would place you under a fraud investigation for a one time shortage of a petty sum like $100.

If you can erase any memory from your mind which one would it be?

Description : If you can erase any memory from your mind which one would it be?

Last Answer : You really want to know? It’s not nice.

Is it possible for another individual or company to erase things off of your facebook?

Description : Is it possible for another individual or company to erase things off of your facebook?

Last Answer : Stuff that is linked from others, or came from others, or tags other people can be removed without your consent, since it wasn’t “yours” to begin with.

How do I erase password protection on an external hard drive?

Description : How do I erase password protection on an external hard drive?

Last Answer : I will have to double-check how Lacie does things, but I know that there are certain security things that Linux ignores, especially if you use a distro that is geared specifically for intrusion testing.

Is there a one click button to erase history?

Description : Is there a one click button to erase history?

Last Answer : Fluther is not really a good place to find programming help (that’s my first-hand experience). I would recommend asking this question at stackoverflow.com, which is mostly designed for programming help.

Can I erase a domain and reuse it somewhere else?

Description : Can I erase a domain and reuse it somewhere else?

Last Answer : answer:Yes, but you need to go through a process to move it from one host to another. It's a bunch of steps and it takes about a week. Not difficult, just time consuming. Start out by ... your current domain owner and getting the transfer serial number - the new domain host will need that for sure.

Is there a way to erase an existing background to a photo that you took and create a new one?

Description : Is there a way to erase an existing background to a photo that you took and create a new one?

Last Answer : It can be done pretty easily if you’re familiar with Photoshop or similar image manipulation programs, but I don’t know about programs specifically for cutting you out of a photo.

When you erase a word with a pencil, where does it go?

Description : When you erase a word with a pencil, where does it go?

Last Answer : Even though I’m the first to answer this I’m sending it to Auggie as possible question of the day. Wow, that’s great.

If you could erase all of the useless information in your brain and fill it with something else, what would you choose?

Description : If you could erase all of the useless information in your brain and fill it with something else, what would you choose?

Last Answer : I’d cram my brain full of engineering knowledge, languages, and motor vehicle repair skills.