Interested to Buy Any Domain ? << Click Here >> for more details...
difference between stored procedure and function?
- 4 Answers
- 9275 Views
- Syntel, I also Faced
- E-Mail Answers
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 difference between set functions and filter function in dimensional data?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What is the size of database for you project?
Why cognos scenario is used?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
What is the advantage of using shortcuts?
what is hints in cognos and where we use it.
whats the difference between previous version of cognos and cognos 8 BI?
What DB View and Bus View?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What is the metric store database?
Explain the difference between native sql and cognos sql?
What are the ways to import data into catalog?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
