Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 9285 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 |
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
In which types of reports does the page breaks applicable in Cognos...?
What are variable report studio?
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
What is snapshot ?
8. Can you use calculations in report headers and footers? How?
what do u mean by bridge group? where we r using this one?
what is the difference between native sql and cognos sql?
What's the differance between each studio in cognos 8?
Explain the characteristics of cognos?
1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
Teradata 
