Cursors are of two types
1. Implicit Cursors: - Whenever we execute sql statements oracle server assigns a work area called private sql area to store precessed infomation. The most recently used work are can be accessed using SQL%. In implicit cursors open, fetch , close operations are automatically performed by the server implicitly.
2.Explicit cursors:- In explicit cursor you can explicitly assign a name to process information stored in private sql areas. This process involves four steps
II) Explicit (Explicit cursor has three sub-types)
1) Simple Cursor
2) Parameterised Cursor
3) Ref Cursor
1. Implicit Cursors: - Whenever we execute sql statements oracle server assigns a work area called private sql area to store precessed infomation. The most recently used work are can be accessed using SQL%. In implicit cursors open, fetch , close operations are automatically performed by the server implicitly.
2.Explicit cursors:- In explicit cursor you can explicitly assign a name to process information stored in private sql areas. This process involves four steps
II) Explicit (Explicit cursor has three sub-types)
1) Simple Cursor
2) Parameterised Cursor
3) Ref Cursor
No comments:
Post a Comment
Please Provide your feedback here