Original: http://ntk2006.blog.sohu.com/135331235.html
Cursor ConceptCursors provide a flexible way to retrieve and operate data from tables. cursors are mainly used on servers to process SQL statements sent from clients to servers, or data
I. cursor Recognition
Cursor allows you to access the result set returned by SQL Server row by row.A major reason for using cursor is to convert the set operation into a single record processing method.After retrieving data from a database using
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
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,
Oracle Database: PL/SQL cursor overview, oracleplI. cursor Concept
Literally, it refers to a swimming cursor, which is a handle or pointer pointing to the context area.
When performing the CRUD operation in the PL/SQL block, ORACLE allocates a
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
CursorA cursor is a data buffer opened by the system for the user, which holds the results of the SQL statement execution. Each cursor area has a name that allows the user to retrieve the record from the cursor one at a-and assign it to the main
I. EXPLICIT cursorExplicit is relative to the implicit cursor, that is, there is a clear declaration of the cursor. The declaration of an explicit cursor is similar to the following (specific syntax for Plsql ref doc):Cursor cursor_name (parameter
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.