Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 9286 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
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
How can you link a query to a data container manually in Report Studio?
Can you define cognos impromptu?
What is the difference between regular dimension and derminant?
What is meant by Reportstudio shortcut?
how to create measures and dimensions?
difference between impromptu and cognos8
what are the dimensions that you have in your current project?list them?
--------------Explain Table of contents?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What are the different types of important services used in cognos?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What errors and types of errors you faced in Cognos ReportNet? what is catalog and types of catalogs in cagnos and which is better?
