What the PAUSE package procedure does ?

1 Answer

Answer :

Pause suspends processing until the operator presses a function key

Related questions

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

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

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

Description : What ERASE package procedure does ?

Last Answer : Erase removes an indicated global variable.

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.

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.

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

Last Answer : User_objects, User_Source and User_error.

Description : What are the different types of Package Procedure ?

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

Description : What is a Package Procedure ?

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

Description : What Enter package procedure does ?

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

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

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

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

Last Answer : No

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.

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

Last Answer : True

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

Last Answer : SHOW ERRORS

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.

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)

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)

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.

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

Description : Error_Code is a package proecdure ?

Last Answer : a. True b. false False

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

Last Answer : No

Description : What is a Text_io Package?

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

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

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

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

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

Last Answer : I) FALSE

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

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.

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.

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.

Description : What is a stored procedure ?

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

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

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

Description : Give the structure of the procedure ?

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

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.

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.

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

Last Answer : False

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

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

Description : Is there a name for the phenomenon that when you pause a video at any point, the person in it makes a derp face?

Last Answer : Gotcha journalism comes to mind. Or candid camera.

Description : When you hear of the death of others who might be famous, or whom you know personally but younger than you, does it make you take a pause on life?

Last Answer : I think about what that person meant to me. In the case of George Michael I think about how I really liked his music from when I was around the age of 18, first with Wham and then as a solo artist. I ... at the age where people who are close to my age are dying. I feel 53 is way too young to die.

Description : Has the results of the Presidential election given you pause for who know?

Last Answer : answer:I have not booted anyone but I believe I may have been booted by several on FB but, seriously, don't care. Sorry if I offended by not seeing things the way I should have.. Also, I ... believe they are misguided but not a single person I know is purposely hurtful or full of hate for others.

Description : Where in the soup-making process can I insert an overnight pause?

Last Answer : answer:Yes, @Jeruba I almost always make our soup for the next day. If adding milk, I do that just prior to serving. The overnight break happens after step 4.

Description : The circle of life...do you take pause or simply move on?

Last Answer : Scathed, most definitely. @Cruiser, my husband passed three years ago and I am still very much in the aftershocks. We were married 33 years, add on the courting years and it was more like 37. We were ... happening with the 5 senses is a good thing. Guess you could call it trying to smell the roses

Description : How often do you use Craigslist and does this news story give you pause?

Last Answer : I’ve read stories like that all the time. People who place or answer Craig s List get robbed about once a month or more. Last time it was a litter of valuable puppies that got stolen.

Description : When do you think online videos will have features of VHS videos: Pause at the exact place the first time, Slow Motion, etc?

Last Answer : And be able to come back to it later and start where you left off? Netflix can already do that, as can Hulu.

Description : How do people talk nonstop, when I pause and it takes me time to think?

Last Answer : answer:They are basically speaking their thoughts out loud while they are thinking them. Where as you probably are trying to take time and make sure your words come out the way you want them to. Some people don’t think BEFORE they speak. I am guilty of this.

Description : Is it difficult for females to pause mid-stream while urinating?

Last Answer : Not difficult. Especially if they’ve been practicing their kegels.

Description : Can I pause, reboot and resume an After Effects render?

Last Answer : Not that I have ever heard of. Maybe it’s a new feature I haven’t gotten to yet

Description : How Does My CD Player Understand Where to Pause?

Last Answer : CD still spins. But the laser doesn’t move. They are two separate things. edit :: The laser is what reads the CD.

Description : How long can u use Pause button on Cd portable player?

Last Answer : Since pausing a cd causes it to remain spinning, it uses a fair amount of juice... probably almost as much as playing. I suspect some CD players will auto stop--similar to a VHS. That being said, it may not be that bad. Considering how low the stakes are, I would say just test it for yourself.