INTERVIEW QUESTIONS ORACLE PL-SQL DETAILS

Question: What is difference between stored procedures and application procedures,stored function and application function?

Answer: Stored procedures are sub programs stored in the database and can be called & execute multiple times where in an application procedure is the one being used for a particular application same is the way for function

Stored procedures are sub programs stored in the database and can be called & execute multiple times where in an application procedure is the one being used for a particular application same is the way for function
Source: CoolInterview.com

Stored Procedure/Function is a compiled database object, which is used for fast response from Oracle Engine.Difference is Stored Procedure must return multiple value and function must return single value . Source: CoolInterview.com

Procedure:-
Execute as a PL/SQL
statement,No RETURN clause in
the header,Can return none, one,
or many values,Can contain a RETURN
statement
Function:-Invoke as part of an
expression,Must contain a RETURN
clause in the header,Must return a single value,Must contain at least one RETURN statement Source: CoolInterview.com

Stored procedures are sub programs stored in the database and can be called & execute multiple times where in an application procedure is the one being used for a particular application same is the way for function

Stored Procedure/Function is a compiled database object, which is used for fast response from Oracle Engine.Difference is Stored Procedure must return multiple value and function must return single value . Source: CoolInterview.com

The basic difference between function and procedure is that a procedure can never be used in a sql statement while a function can be used Source: CoolInterview.com

Difference between Stored Procedure and Application Procedure:
Stored Procedure is a named PLSQL block that will be compiled and used for further use. If maintained across Servers, they can be used for different applications and Users. Application Procedures are the one which will be used for local apps, this can be called local block of code. Apart from technical characteristics, same will apply to the differences between Stored Functions and Application Functions.
Difference between Procedures and Functions:
a. Functions can be used in a select statement where as procedures cannot
b. Procedure takes both input and output parameters but Functions takes only input parameters
c. Functions cannot return values of type text, ntext, image & timestamps where as procedures can
d. Functions can be used as user defined datatypes in create table but procedures cannot
***Eg:-create table <tablename>(name varchar(10),salary getsal(name))
Here getsal is a user defined function which returns a salary type, when table is created no storage is allotted for salary type, and getsal function is also not executed, But when we are fetching some values from this table, getsal function get’s executed and the return
Type is returned as the result set. Source: CoolInterview.com

The syntax for stored procedures starts with "create or replace" , while the application procedure starts with "procedure". Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question