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.

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   AIG, Niteo,

---

how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 Answers  

---

Explain about embedded & standalone filters?difference between them

1 Answers  

---

What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

1 Answers  

---

What is defined as catalog and types of catalogs in Cognos?

0 Answers  

---

---

what is view? types of views?

3 Answers   HCL,

---

Whrer u can save the Report net documentation in our local system?

1 Answers  

---

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

2 Answers   TCS,

---

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

0 Answers   Genpact,

---

if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............

1 Answers   Mphasis,

---

11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  

---

How create measures and dimensions?

0 Answers  

---