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 is auto invoicing? : oracle accounts receivable

661

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

627

---

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

674

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1245

---

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

762

---

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2392

---

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

644

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1638

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

650

---

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?

706

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1920

---

What do you mean by Oracle MEDIA RECOVERY?

729

---

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

1768

---

what are the API of GL,PO,AP

1779

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1778

---