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
- 4985 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 |
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Which are the five query types available in oracle?
How to update values on multiple rows in oracle?
What are the differences between number and binary_float in oracle?
Differentiate between TRUNCATE and DELETE?
What is cursor
What is an Oracle view?
Explain the difference between sap and oracle?
How to use "in" parameter properly?
Explain oracle instance.
what are the differen between key flexifild and discriptive fiexifild.
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
Oracle General 
