Answer / suresh kumar somayajula

Declaring a CURSOR
Open the CURSOR
FETCH the rows from the CURSOR
CLOSE the CURSOR...

Answer / chandrasekar

Select,for loop

Answer / nishi

Declaring a CURSOR

Open the CURSOR

FETCH the rows from the CURSOR

CLOSE the CURSOR...

Answer / vijay

cursor
open
fetch
close
attributes
%found,
%notfound
%isopen
%rowcount
loop
whlie loop
for loop

What is different between union and minus?

7 Answers   Accenture, TCS,

---

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

---

Why is the cursor important?

0 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

What are the uses of merge?

0 Answers  

---

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

How does one load ebcdic data? : aql loader

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

What is a composite primary key?

0 Answers  

---

how to enter characters as hex numbers? : Sql dba

0 Answers  

---

What are different categories of sql commands?

0 Answers  

---