what are the different types of cursors? explain?
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 |
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
How do I start tns listener?
How to open a cursor variable?
Do View contain Data ?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
What is the difference between PFILE and SPFILE in Oracle?
Why is oracle database so popular?
What do you know about normalization? Explain in detail?
master table and child table performances and comparisons in Oracle ?
How do I know if oracle is installed on windows?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?