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 difference between java script and html in cognos?

1 Answers   IBM,

---

what are the joins present in reportnet?which is most widely used?

4 Answers   Covansys, IBM, Satyam,

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,

---

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

---

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,

---

---

What do you mean by query studio?

0 Answers  

---

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

0 Answers  

---

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

4 Answers   Tech Mahindra,

---

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,

---

What is a Query Subject?

0 Answers  

---

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?

0 Answers   TCS,

---

Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  

---