How do you optimize a stored procedure query?

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

What is the difference between drop and truncate commands?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

Explain the select statement in sql?

0 Answers  

---

how to include numeric values in sql statements? : Sql dba

0 Answers  

---

What is the difference between delete and truncate commands?

0 Answers  

---

What is keys and its types?

0 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---