cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes

cursor attributes are %isopen ,%notfound,%found,%rowcount
but is any attributes there other than these? please tell me
asap ..

Question Posted / vishal.moluguri

2 Answers
4935 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than th..

Answer / b.chandan kumar patra

Yes there is another two attributes are there,
these are, %bulk attribute and another is %bulk rowcount.

Is This Answer Correct ?

2 Yes

0 No

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than th..

Answer / naresh

Yes the above answer is true, and te attributes that you
have mentioned are for explict cursor.

for implicit cursor just add SQL infront of all the attributes.

Like
SQL%isopen,
SQL%found

Cheers!
Naresh

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers HCL,

What is bulk load in oracle?

0 Answers

How to invoke the original export import utilities?

0 Answers

How different is ms access and oracle?

0 Answers

How can you merge two tables in oracle?

0 Answers

What are the differences between primary key and unique key?

0 Answers

Is it possible to enter only time value into a column of a table in sql?