Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 9105 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
How is possible this scenario using in type-in prompt.?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is meant by Reportstudio shortcut?
How can I test reports in cagonos?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Can you define a catalog and types of catalogs in cognos?
What are cognos connection initial page components?
How to create a cube in Transformer? What is the process? Please mention process thank u
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
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..
what is the procedure for scheduling conditional rendering?
Explain what is the main advantage of impromptu over cognos reportnet?
Explain the characteristics of cognos?
How do you Parametermap variables in Quiries?
