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

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.

2181

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2361

---

8. Supporting AP, AR and GL?

2301

---

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

1113

---

HOW TO SPOT AHIERARCHY?

2285

---

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

2629

---

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

1379

---

What is the sql query to find the employee who has Nth maximum salary?

5314

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1201

---

what is semphore explian it?

2805

---

key flexfield structure

2166

---

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

---

1. What is PO rate variance gain and loss?

2907

---

Explain the payment term in ar. : oracle accounts receivable

1101

---

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

1145

---