Answer / sushant

It is just to check whether the query which we provide is
quiet simple n takes less time to compile as compared to
other querys !!!
Mostly its a DBA part !!

Answer / sudipta santra

First u need to take explain plan of the proposed query then
you can identify for which join condition is costlier. By
watching this then you can modify the condition logic of the
query.

There are so many logic for make a query tune.

Can we create database in oracle using command line ?

0 Answers   MCN Solutions,

---

After update how do u know how many records got updated

4 Answers   TCS,

---

what is primary key?

9 Answers  

---

How to Identify the previously inserted/updated records in already populated table.

0 Answers  

---

How to connect to a remote server?

0 Answers  

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

How to start instance with a minimal initialization parameter file?

0 Answers  

---

How to use "startup" command to start default instance?

0 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

can a view be updated?

3 Answers  

---