difference between stored procedure and function?
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
How can we Maintain the Cube Security by Category level and Dimension level ?
----------------Diff b/w Dimensional modeling and Relational modeling?
How to create a cube in Transformer? What is the process? Please mention process thank u
How can I test reports in cagonos?
What are the message flows?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Define query studio?
What is the function of cognos dispatcher?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What is the report studio?
what is the difference between querystudio in reportnet and cognos8
what are the filters in framework manager and report studio?
Can you define materialized view?
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
Explain is there any comparison available for cognos reportnet vs crystal reports?