Answer / Sameer Kumar

Cursors are used in PL/SQL to work with sets of rows that are returned from a SELECT statement, and manipulate them one by one or in batches.

what are ddl statements in mysql? : Sql dba

1 Answers  

---

Can a foreign key have a different name?

1 Answers  

---

Explain Connect by Prior?

2 Answers  

---

What is pivot in sql?

1 Answers  

---

how to create a database in oracle?please gve anser with example

1 Answers  

---

What is sql architecture?

1 Answers  

---

What is varchar sql?

1 Answers  

---

Can instead of triggers be used to fire once for each statement on a view?

1 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

What is a stored procedure ?

9 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---