Answer / thanjairajan@gmail.com

The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.

For example:

WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;

Answer / krishna

Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated

what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

0 Answers   HCL,

---

can any one say the which is the best performance in framework manager

1 Answers  

---

Can anyone tell me the step by step process how to connect cognos to oracle?

3 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?

1 Answers   IBM,

---

Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

2 Answers   SAP Labs,

---

------------- How to identify the Revenue Column in Report?

0 Answers  

---

how you create security to cubes ?????

4 Answers   iFlex, iGate,

---

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  

---

what is view? types of views?

3 Answers   HCL,

---

Can you explain cognos planning?

0 Answers  

---

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

---