What are Procedure,functions and Packages

What are Procedure,functions and Packages
by

1 Answer

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 Return values while Functions return one One Value
Packages :: Packages Provide a method of encapsulating and storing
related procedures, functions, variables and other Package Contents
by

Related questions

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 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 the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

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)

What ERASE package procedure does ?

Description : What ERASE package procedure does ?

Last Answer : Erase removes an indicated global variable.

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.

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

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;

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.

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.

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

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

Explain the use of table functions.

Description : Explain the use of table functions.

Last Answer : Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

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 is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What is difference between Procedures and Functions ?

Description : What is difference between Procedures and Functions ?

Last Answer : A Function returns a value to the caller where as a Procedure does not.

How packaged procedures and functions are called from the following?

Description : How packaged procedures and functions are called from the following?

Last Answer : a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS?? a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME ( ... .PROCEDURE if the procedures does not have any out/in-out parameters. A function can not be called.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

What are the built-ins used for finding object ID functions?

Description : What are the built-ins used for finding object ID functions?

Last Answer : Find_group(function) Find_column(function)

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

How data is shared by functions in a procedure oriented programming?

Description : How data is shared by functions in a procedure oriented programming?

Last Answer : Stack memory

How common is it, where you live, for packages to be delivered to your neighbours when you are not at home?

Description : How common is it, where you live, for packages to be delivered to your neighbours when you are not at home?

Last Answer : Standard procedure here too (Netherlands). Recently DHL and the Dutch postal services are also asking their customers whether they want to give up a secondary address (other than neighbors, or neighbors, or ... the supermarket (very rarely I have to go to my neighbors; vice versa much more often).

Do Q tips packages have "do not use to clean ear" label?

Description : Do Q tips packages have "do not use to clean ear" label?

Last Answer : See link and picture link Yes, it’s on the package.

Doesn't it seem rude or scary how they are making food packages smaller with the same or higher price?

Description : Doesn't it seem rude or scary how they are making food packages smaller with the same or higher price?

Last Answer : A typical “pound” of coffee shrank to 13 oz. many years ago.

Is it common for a different postperson to deliver Priority Express International packages?

Description : Is it common for a different postperson to deliver Priority Express International packages?

Last Answer : Yes it is common.

Why did all packages ordered from the same place arrive separately?

Description : Why did all packages ordered from the same place arrive separately?

Last Answer : Different delivery companies? Sent at different times?

How do I make a simple aid to carry packages up flights of stairs?

Description : How do I make a simple aid to carry packages up flights of stairs?

Last Answer : A back pack is the most efficient way but would not work for furniture. Are there windows on the stairs where you could hoist things up on the end of a rope in a bag or basket?

Is it better and cheaper to plan a trip to Tokyo yourself or through tour packages?

Description : Is it better and cheaper to plan a trip to Tokyo yourself or through tour packages?

Last Answer : answer:I would say it’s better to be a traveler than a tourist. ;) Both can be very economical if you do your research ahead of time and ask people in the know.

"Triple Play" packages from the cable company… is it a scam?

Description : "Triple Play" packages from the cable company… is it a scam?

Last Answer : answer:Scam, no. Overpriced, probably. Ask yourself if their pricing for cable telephone service makes any sense at all. Usually, the answer is no . The real issue is that the charge you whatever they can, ... for you based on your needs and usage patterns. In my case, the answer was a clear no .

What does UPS do when a plane crashes and all the packages are destroyed?

Description : What does UPS do when a plane crashes and all the packages are destroyed?

Last Answer : answer:They have a complete shipping manifest available through the tracking system. And I imagine they sent out automatic emails to the senders ASAP. I can get emails from UPS when ... can pick up replacements and expedite shipping for replacements, all covered by business interruption insurance.

How would you handle UPS packages with this setup?

Description : How would you handle UPS packages with this setup?

Last Answer : Pick them up from the depot…

What exactly is the law regarding packages sent to you that you didn't order (see details)

Description : What exactly is the law regarding packages sent to you that you didn't order (see details)

Last Answer : answer:If this happened to me, and I was genuinely interested in returning the items cost-free, my first step would be to phone the merchant and explain to the manager what had happened. They will very ... a bad idea), but so he knows that this is happening. The merchant probably won't inform him.

How often do you use the services of the US Post Offices for sending mail/packages?

Description : How often do you use the services of the US Post Offices for sending mail/packages?

Last Answer : I frequently mail and receive packages, but it is often done through UPS, not USPS.