how to run cursor in oracle

Today, we will briefly summarize the usage of cursor in PL/SQL. Cursor category: -- Explicit cursor-- Static cursor | | -- Implicit cursorCursor |-- Strong type (Restriction), specifying the return type-- Dynamic Cursor -- ref cursor |-- Weak type

Basic Oracle cursor and basic oracle cursor I. cursorThe cursor is used to process the multi-row records retrieved from the database (using the SELECT statement ). With the cursor, the program can process and traverse the entire record set returned

1, what is a cursor? ① retrieves the result set from the table, and the mechanism from which each point points to a record for interaction.The operations in the ② relational database are performed on the complete rowset.The rowset returned by the

Transferred from: http://developer.hi.baidu.com/#/detail/15344654this day's simple summary of the usage of cursor (cursor/cursor) in pl/ SQL. I believe many DBAs who are engaged in development or maintenance have encountered similar face-to-face

The difference among Cursor, hidden Cursor, and dynamic Ref Cursor is displayed in PLSQL. plsqlref1. Explicit cursorExplicit is relative to implicit cursor, that is, there is a clear declared cursor. The declaration of an explicit cursor is similar

Today, we will briefly summarize the usage of cursor in PL/SQL. I believe many DBAs who are engaged in development or maintenance have encountered similar face-to-face problems when looking for a job: Please briefly describe the type of the cursor,

1, what is a cursor.① retrieves a result set from a table from which the mechanism for interacting with each record is pointed.Operations in the ② relational database are performed on a complete rowset.The rowset returned by the SELECT statement

http://blog.csdn.net/gyflyx/article/details/6889028Reference one, explicit cursorExplicit is relative to the implicit cursor, which is the cursor with a clear declaration. The declaration of an explicit cursor is similar to the following (the

When Oracle Database executes a SQL statement, it stores the result set and processing information in an unnamedprivate SQ L area. A pointer to the unnamed area, called acursor, lets youretrieve the rows of the result set one at a time.Cursor

I. EXPLICIT cursorExplicit is relative to the implicit cursor, which is the cursor with a clear declaration. The declaration of an explicit cursor is similar to the following (the detailed syntax participates in PLSQL ref doc):Cursor cursor_name