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

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2203

---

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

1283

---

What is an Oracle database Partial Backup?

1167

---

what are basic modules required to implement oracle application in any oraganisation?

2214

---

Explain prerequisites and post activities of oracle database installation

2138

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2263

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7682

---

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

2332

---

difference of using cursor for loop and open,fetch,close.which one is better

1806

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2523

---

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

2226

---

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

1128

---

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

2195

---

How to clone the database using RMAN back

2245

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

---