Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 8903 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 meant by junk dimension?
What is the difference between Standard and Metrics folder?
Can you define a datastore in cognos?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
can you tell me what are the dimension tables are used in project
What do you mean by Drill down and Drill Up?
Why are meta service important then other services?
What are the roles defined by cognos platform?
What is set to be Cognos configuration?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
How can I schedule reports in cognos?
What are shortcuts? Where it can be used? What are the advantages?
How to create a cube in Transformer? What is the process? Please mention process thank u
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
