Answer Posted / sunil

delete emp where empno not in(select distinct empno from emp);

For example we have duplicates in empno column then write
query like above...whatever column u want u can write..

What is a trace file and how is it created in oracle?

1046

---

Hi Can any one tell me what are the API's used in requisition import.

1917

---

How to commit the current transaction in oracle?

1107

---

Can a formula column referred to columns in higher group ?

2496

---

Why packages are used in oracle?

1064

---

Explain what are the type of synonyms?

1103

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2199

---

How to set up autotrace for a user account?

1051

---

Explain the use of rows option in imp command.

1079

---

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.

3322

---

Please explain drop constraint oracle?

1088

---

Is insert autocommit in oracle?

1063

---

How to get the Installed Oracle Version Information ?

1117

---

How oracle handles dead locks?

1064

---

What is oracle used for?

1020

---