Answer / Sanjay Kumar Choudhary

A Magic Query, in Oracle, is a pre-built SQL statement designed to quickly return useful information about the database schema, performance, or other aspects of the system. Examples include DBA_HIST_SQLSTAT, GV$SQLAREA, and DBA_SEGMENT_STATISTICS.

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

How to join two tables in a single query using oracle?

1 Answers  

---

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,

---

How to list all user accounts in oracle?

1 Answers  

---

What are the differences between blob and clob in oracle?

1 Answers  

---

Why packages are used in oracle?

1 Answers  

---

can you write commit in triggers?

4 Answers  

---

What are the oracle built-in data types?

1 Answers  

---

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1 Answers   Oracle,

---

Which is better Oracle or MS SQL? Why?

3 Answers   Bally Technologies,

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---