Answer Posted / venkataselvaraj@gmail.com

SELECT PRODUCT_ID, PRICE FROM PRODUCTS
GROUP BY PRODUCT_ID, PRICE
HAVING COUNT(*) = 1;

what is dynamic SGA and static SGA

4358

---

What are a cluster and non-cluster index?

984

---

What is format trigger?

2040

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2149

---

How to assign a table row to a record variable?

990

---

Explain the characteristics of oracle dba?

1084

---

What is bulk copy or bcp in oracle?

1083

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1040

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2071

---

How to get a list of all user accounts in the database?

1057

---

Explain the use of rows option in exp command.

1052

---

What are the attributes of the cursor?

958

---

How to use in conditions in oracle?

1017

---

What suggestions do you have to reduce the network traffic?

921

---

What are triggers in oracle?

989

---