difference between stored procedure and function?
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 difference between page break and section report?
What are the services provided in cognos 8?
What is the difference between the content store and content manager?
What is the difference between group and associare?
What is called Cognos powerplay?
Can you define cognos decision stream?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What are the different uses of a repository manager?
Explain difference between powerplay transformer and power play reports?
New coloums are added in database, then how you know in report level
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
What are the different kinds of panes included in cognos?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
how you provide security to reports? How you provide security to packages ?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.