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
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
how to explain health care project and which reports we can create in health care doain?
What are the advantages of cognos?
Why need staging area database for dwh?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is difference between content store and content manager?
Can you define pivot?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
Can we test the report other than manual testing?
how can you get the errors in job? when loops are araised we get error?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
When we save a report in report studio with what extn it save?
what is the difference between filter and condition?
How Metrics Studio is better than Report Studio?
What is the use of cognos decision stream?