Types of cursors?

Answer Posted / manoj

Declare
var emp.empno%type;
emp emp.ename %type;
Cursor emp_cursor is
Select empno,ename
From emp;
Begin
Open cursor;
For I in 1..11 loop
Fetch emp_cursor into vno,vname;
Dbms_output.putline(to_char(vno) ||? ?
||vname);
End if;
E nd;

Is This Answer Correct ?    12 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me the scenarios of the independent in reports

2109


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1976


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2597


Can we create tables in apps schema?

622


Explain oracle apps architecture.

767






What are the Standard Reports and Forms in HRMS?

1773


what is the difference between request group and request security in oracle apps?

5050


Can you define an erp system?

681


What is a value set? List its various types.

650


In support project one ticket alloted which steps follows manualy tell me ?

2224


Are you familiar with internet architecture of oracle apps 11i?

630


In sequence i want to 11 and 15th values how we will write?

1573


testing tools?

1753


What is a flexfield? List out its types.

668


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1654