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
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What are initial page components of Cognos connection?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
How can we create a dynamic column name in cognos?
Can you define a catalog and types of catalogs in cognos?
How can I schedule reports in cognos?
how to test reports in cognos?
What are all types of Batches?
how u will determine the performence tune will occur either in report or system
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
how to create measures and dimensions?
What is meant by junk dimension?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com