Answer Posted / sharath

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


select

(select date from t1) 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. 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 Cross Validation & Adi?

1161

---

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7972

---

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1348

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7682

---

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

2297

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2078

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2135

---

can u give guidance abt packages of plsql

2176

---

Explain prerequisites and post activities of oracle database installation

2137

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2313

---

How would you go about increasing the buffer cache hit ratio?

2604

---

How many segment are present in Oracle Manufacturing

2320

---

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

1157

---

which one is currently in used software cmpanies.

2159

---