difference between stored procedure and function?
- 4 Answers
- 8146 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / arkchowdary
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 |
Post New Answer View All Answers
What is the use of Cognos scenario?
What is the function of cognos dispatcher?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What are the ways to import data into catalog?
Can you define framework manager?
What is the metric store database?
how to perform single sign in cognos by using url?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is difference between data mart and data warehouse?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
----------------Describe DWH Architecture?
What are the two types of framework manager?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
When we save a report in report studio with what extn it save?
