Answer / kumar srinivasalu

Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time

Answer / somashekhar m

By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.

in ACID cursor works for consistency of the data.

What is a full join?

0 Answers  

---

What are aggregate and scalar functions?

0 Answers  

---

What are expressions?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

What is sql architecture?

0 Answers  

---

---

Is primary key clustered index?

0 Answers  

---

what is bcp? When does it used? : Sql dba

0 Answers  

---

What are the set operators in sql?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

What is meant by temporal data?

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---