Why stored procedure is better than query?

0 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

What are different types of statements supported by sql?

0 Answers  

---

What are % type and % rowtype?

0 Answers  

---

what is index? : Sql dba

0 Answers  

---

What is difference between stored procedures and application procedures?

0 Answers  

---

What does pragma mean?

0 Answers  

---

Do foreign keys improve performance?

0 Answers  

---

What is crud diagram?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---