Is DML statements are cursors?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • krishhhna
    New Member
    • Aug 2007
    • 13

    Is DML statements are cursors?

    is dml statements are cursors or not ? if yes how it is ?
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    No DMLs are not cursors.

    Comment

    • gintsp
      New Member
      • Aug 2007
      • 36

      #3
      Originally posted by krishhhna
      is dml statements are cursors or not ? if yes how it is ?
      Every DML (at least all SELECT, DELETE, UPDATE, MERGE and also INSERT with subqueries) statement is cursor. There are two types of cursors - implicit (managed automatically, for each above mentioned statement) and explicit where user explicitly writes OPEN, FETCH and CLOSE statements.
      See more Managing Cursors in PL/SQL

      Gints Plivna

      Comment

      Working...