Answer / m m naidu

A Procedure is a sub-program that performs a specific
action.

A Procedure can be called from PL/SQL Block or from another
Procedure also.


A function is very similar to a Procedure. Both take
arguments, which can be of different modes. Both are
different forms of PL/SQL blocks. Both can be stored in the
database.
A procedure call is a PL/SQL statement by itself, while a
Function call is called as part of an expression. And a
Function must return

Answer / vsandhyana

Function can call anywhere in your select query but store
procedure cannot call from the select statement.

store procedure may or may not return values but function
should return value.

Thanks,
Vsandhyana

Answer / 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.

Answer / ravi v

Function returns only 1 value, where as stored procedure
returns mutiple values.

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

0 Answers  

---

what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.

2 Answers  

---

how to find the rank in report studio? i need steps for this question.

2 Answers  

---

what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

2 Answers   IBM,

---

Explain what is the main advantage of impromptu over cognos reportnet?

0 Answers  

---

How to select multiple values from type-in prompt?

0 Answers  

---

What is set to be Cognos configuration?

0 Answers  

---

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

---

what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

2 Answers   HCL,

---

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

7 Answers  

---

How can we find out cardinality between two tables?

3 Answers   IBM,

---

what is physical layer and presentation layer?

2 Answers   Zensar,

---