Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 9299 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m m naidu
A Procedure is a sub-program that performs a specific
action.
A Procedure can be called from PL/SQL Block or from another
Procedure also.
A function is very similar to a Procedure. Both take
arguments, which can be of different modes. Both are
different forms of PL/SQL blocks. Both can be stored in the
database.
A procedure call is a PL/SQL statement by itself, while a
Function call is called as part of an expression. And a
Function must return
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vsandhyana
Function can call anywhere in your select query but store
procedure cannot call from the select statement.
store procedure may or may not return values but function
should return value.
Thanks,
Vsandhyana
| Is This Answer Correct ? | 3 Yes | 1 No |
PL/SQL------------- It is a named PL/SQL Block.
------------- Which can take 1 or more values.
------------- It accepts Parameters.
Usage-------------- Reusability.
-------------- Precompatibility.
Whereas
Functions----------- It is a named PL/SQL Block.
----------- Which can take 1 or more values.
----------- It must a Returns value by using
return statement.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ravi v
Function returns only 1 value, where as stored procedure
returns mutiple values.
| Is This Answer Correct ? | 1 Yes | 2 No |
can anybody tell me when do use 'running total'...give an example for the usage of running total
Can you define folder?
What is defined as catalog and types of catalogs in Cognos?
..Architectural difference between cognos reportnet and cognos8?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is called a slice?
------------------- What is Busschema?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
----------------------What are the User Securities?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
Teradata 
