Interested to Buy Any Domain ? << Click Here >> for more details...
cursor attributes are %isopen ,%notfound,%found,%rowcount
but is any attributes there other than these? please tell me
asap ..
- 2 Answers
- 4979 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is sharded cluster?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is dictionary cache ?
How to invoke the original export import utilities?
What is hash cluster in oracle?
what is the use of composite key constraint?
why pl sql doesn't support retrieving multiple records
How would you design a database for an e-commerce website?
How to create a table interactively?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the sid in oracle?
defination of bitmap index
Oracle General 
