1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What action do you have to perform before retrieving data
from the next result set of a stored procedure ?

Question Posted / guest


What action do you have to perform before retrieving data from the next result set of a stored pro..

Answer / Ashish Kumar Johri

Before retrieving data from the next result set of a stored procedure, you typically need to call a fetch or similar method that moves to the next record in the result set. This operation is usually repeated until there are no more records left in the result set.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is sql an operating system?

1 Answers  

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

How do you change a value in sql?

1 Answers  

What is crud sql?

1 Answers  

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

How the execution will be done in exceptions?

2 Answers  

What is sql and also describe types of sql statements?

1 Answers  

what is unique key constraint? : Sql dba

1 Answers  

What if we write return in procedure?

1 Answers  

Write a sql select query that only returns each name only once from a table?

1 Answers  

What is sql profiler in oracle?

1 Answers  

What are sql data types?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories