pl sql ref cursor example

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,

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

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

1, what is a REF CURSOR?A temporary object that dynamically associates a result set. That is, dynamically deciding to execute the query at run time.What is the effect of 2,ref cursors?Implements the ability to pass result sets between programs,

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

1. Cursor conceptLiterally, 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 context zone for it in the memory. The database language

Using ref cursor, you canProgramInter-pass result set (a program opens the cursor variable and processes data in another program ).You can also use ref cursor to implement bulk SQL to improve SQL Performance. There are two types of ref cursor: