Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 9077 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is meant by Reportstudio shortcut?
what is the main advantage of impromptu over cognos reportnet?
What are the components used in web tier?
9. What was the most complex type of report you dealt with?
how to create measures and dimensions?
What is an olap designer?
How to create model and how to test model?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
Is it possible to join multiple Databases in a Catalog?
What do you understand by ‘ibm predictive maintenance and quality’?
What are the different types of important services used in cognos?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
