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 the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3888

---

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

2193

---

key flexfield structure

2125

---

What view would you use to determine free space in a tablespace?

2180

---

can we use lexical perameter in oracle plsql if yes how

2280

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2294

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3506

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2017

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2228

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

2102

---

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

1121

---

How many segment are present in Oracle Manufacturing

2279

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1982

---

What is Tax Categories?

2065

---

Can we modify approve purchase order?if yes what is navigation?

1964

---