Answer / chiranjeevi

After generating explan plan the out put of the query
stored in plan_table.from this table if you finding any
table access (full) in output,the query having perfomence
problem.

according you can create the index or primary key or unique
in proper table.

Answer / azuan

example

explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

How do you rename a table in sql?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

Why do we use joins in sql?

0 Answers  

---

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

How do I save the results of sql query in a file?

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

what is the boundary line in varrays?

1 Answers   HCL,

---

Give the order of sql select?

0 Answers  

---

What is oracle sql called?

0 Answers  

---