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

Explain the types of exception?

1194

---

Explain constraining triggers.

1163

---

How to check the server version in oracle?

1141

---

How to start an oracle instance?

1072

---

What privilege is needed for a user to delete rows from tables in another schema?

1133

---

what is Single Byte Overhead...?

2613

---

How to connect asp pages to oracle servers?

1120

---

How to insert a record into a table?

1120

---

What is the data type of dual table?

1064

---

What is meant by joins?

1109

---

How to write a left outer join with the where clause in oracle?

1132

---

How to save query output to a local file?

1084

---

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.

3383

---

How to view the tablespaces in the current database?

1026

---

Is oracle a language?

987

---