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

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2142

---

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.

2433

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1218

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1103

---

What is Tax Categories?

2050

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2160

---

Explain the payment term in ar. : oracle accounts receivable

1055

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2417

---

default triggers available for reports

2156

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1219

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2408

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3865

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2207

---

What are different types of transactions in ar? : oracle accounts receivable

1217

---

Why more redos are generated when the oracle database is in begin backup mode?

1069

---