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

Is primary key clustered index?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---

What is the main difference between sql and pl/sql?

0 Answers  

---

Can we change the table name in sql?

0 Answers  

---