ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How Many Type's of Cursors are Available In PL/SQL?

user-image
تم إضافة السؤال من قبل مستخدم محذوف‎
تاريخ النشر: 2016/05/03
KULDEEP KATARIA
من قبل KULDEEP KATARIA , Team Member

In Oracle, there are two types of cursor available:-

1) Implicit

2) Explicit

Implicit cursor automatically gets created when a select statement is executed.

Explicit cursor are programmer defined for gaining more control/Maniulation over the rows returned by the Select Query.

Gokul Ganesh
من قبل Gokul Ganesh , Senior Product Specialist , Cognizant - India

two types

1. Implicit 

2. explicit

Shessy Chalackal Shaju
من قبل Shessy Chalackal Shaju , Operation Coordinator , Barq Construction and Trading

There are two types of cursor available

1) Implicit

2) Explicit

Implicit cursor automatically gets created when a statement is executed without the explicit cursor.

E.g. While inserting a row the cursor contains the data to be inserted

Explicit cursor are programmer defined for gaining more control over the context area.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

1- Static Cursors

2- Dynamic Cursors

3- Forward Only Cursors

4- Keyset Driven Cursors

المزيد من الأسئلة المماثلة