Answer Posted / sharath

Sorry the query posted above is not the one. Please see the
below query.

Can we use one subquery in another. I have got a situation
like this


select

(select date from t1 where t1.col1=table.col1) date,
((select date from t1 where t1.col1=table.col1)*7) week,
(((select date from t1 where t1.col1=table.col1)*7)
+start_date) transfer

from table;

Somewhat like this.
The point is the first subquery is used in second,
third,fourth subqueries. Instead of writing them again, can
we avoid them.

I needed to know whether the first
subquery can be used in the second subquery and the next
subqueries??Or any hints as such just to make the query
faster??

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2210

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2255

---

How to clone the database using RMAN back

2221

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2850

---

How would you determine who has added a row to a table?

2308

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2506

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1332

---

Can we modify approve purchase order?if yes what is navigation?

2002

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1379

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4438

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1206

---

Differentiate between transaction type and transaction source? : oracle accounts receivable

1113

---

3. Steps in UAT?

2429

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1164

---

How do you create a credit note against an invoice? : oracle accounts receivable

1077

---