1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen ,

1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
names .......

cursor cursor_name is select * from scott.emp

if you use...

cursor_name%found , %rowcount ,%isopen,%notfound...will it
work...

--------------------------

2.what is the difference between the varray and index by
table ..

--------

3.

type type_name is table of number(8,3)

index by binary_integer;

identifier_name type_name;

first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...

with thanks and regards..sarao...

Question Posted / sweetsarao

1 Answers
2522 Views
Satyam, I also Faced
E-Mail Answers

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our u..

Answer / Richa Bansal

The methods you mentioned (first, last, prior, next, trim) are not applicable to Varrays or Index by tables. They are cursor-related functions in PL/SQL used for traversing the result set of a cursor.
To apply these functions to cursors, you can follow these steps:
1. Declare a cursor with SELECT statement.
2. Open the cursor using OPEN keyword.
3. Fetch rows from the cursor using FETCH statement or LOOP construct.
4. Use cursor manipulation functions like PRIOR, NEXT, LAST, and FIRST to navigate through the result set.
5. Close the cursor when done using CLOSE keyword.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer