Mention what does plv msg allows you to do?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

What is a table partition?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

Explain two easy sql optimizations.

0 Answers  

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

what is myisam? : Sql dba

0 Answers  

---

What are properties of the transaction?

0 Answers  

---

what is a table in a database ? : Sql dba

0 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---