Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How can we Maintain the Cube Security by Category level and Dimension level ?

2352


----------------Diff b/w Dimensional modeling and Relational modeling?

14980


How to create a cube in Transformer? What is the process? Please mention process thank u

1758


How can I test reports in cagonos?

957


What are the message flows?

970


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1061


Define query studio?

992


What is the function of cognos dispatcher?

1207


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?

1998


What is the report studio?

1012


what is the difference between querystudio in reportnet and cognos8

2131


what are the filters in framework manager and report studio?

986


Can you define materialized view?

1040


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

2080


Explain is there any comparison available for cognos reportnet vs crystal reports?

949