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??

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2030

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1077

---

can we use lexical perameter in oracle plsql if yes how

2280

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2254

---

Where in the Oracle directory tree structure are audit traces placed?

2589

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2234

---

What is auto invoicing? : oracle accounts receivable

1106

---

can u give guidance abt packages of plsql

2124

---

what is semphore explian it?

2767

---

key flexfield structure

2125

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1112

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2133

---

How would you determine what sessions are connected and what resources they are waiting for?

2085

---

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.

2458

---

how to replace not in with not exist?

3680

---