Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of cursors? explain?
- 4 Answers
- 9968 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srilakshmi paleti
1)Implicit cursor
2)Explicit Cursor
EXPLANATION OF
1)IMPLICIT CURSOR : When ever user performs any DML
operation automatically implicit cursors will raise. User
noneed to create,open,fetch,close the cursor.In PLSQL
select statement also it will work.
2)EXPLICIT CURSOR: User has to create,open,fetch and close
the cursor.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / amit basu
Types of Cursor :
I) Implicit
II) Explicit (Explicit cursor has three sub-types)
1) Simple Cursor
2) Parameterised Cursor
3) Reference Cursor
EXPLANATION OF
I) Implicit--- SINGLE USER ONLY
II) Explicit ----- MULTI USER ONLY
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mohan
Cursor: Cursor is a pointer which is used to fetch one by one record from active set into plsql block.
Types: There are two types of cursors we have in plsql.
they are,
1. Implicit Cursors
2. Explicit cursors
1.Implicit cursors: when ever we perform sql operations then automatically implicit cursors will come into the picture. no need to declare,open,fetch and close implicit cursors.
2.Explicit cursors: These are user defined cursors. we have to declare,open,fetch and close these cursors.
Cursor Attributes:
1.%found
2.%notfound
3.%isopen
4.%rowcount
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / manish kumar
Implicit cursor is declered by System its own But Explicit
cursor is declered by user
| Is This Answer Correct ? | 1 Yes | 1 No |
how to select second mauximum value in a given table under salary column
How do you bind variables in oracle?
What is the use of aggregate functions in oracle?
What is a Sequence ?
What is the disadvantage of User defind function?
what is the difference between oracle enterprise edition and oracle express edition?
What are privileges and grants?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What are Clusters ?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Oracle General 
