Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== Cursor Attributes ======
+Cursor attributes allow you to get information about the current cursor state.
+**Syntax**:
+<code language=sql>
+cursor_name%ISOPEN
+cursor_name%FOUND
+cursor_name%NOTFOUND
+</code>
+  * //cursor_name// is the name of a declared cursor or cursor variable.
+===== %ISOPEN Attribute =====
+%ISOPEN returns //true// if the cursor is open, otherwise it returns //false//;
+===== %FOUND Attribute =====
+%FOUND returns NULL before the first fetch from the cursor, //true// if the last fetch returned a row, and //false// otherwise.
+===== %NOTFOUND Attribute =====
+%NOTFOUND returns NULL before the first fetch from the cursor, //false// if the last fetch returned a row, and //true// otherwise.
+**Example:**
+<code language=sql>
+DECLARE
+  CURSOR c1 IS SELECT name FROM users LIMIT 1;
+  v1 VARCHAR(30);
+BEGIN
+  OPEN c1;
+  IF c1%ISOPEN THEN
+    DBMS_OUTPUT.PUT_LINE('Cursor open');
+  END IF;
+  FETCH c1 INTO v1;
+  IF c1%FOUND THEN
+    DBMS_OUTPUT.PUT_LINE('Row found');
+  END IF;
+  FETCH c1 INTO v1;
+  IF c1%NOTFOUND THEN
+    DBMS_OUTPUT.PUT_LINE('Row not found');
+  END IF;
+  CLOSE c1;
+END;
+</code>
+**Compatibility:** Oracle
+**Version:** HPL/SQL 0.3.11
+**See also:**
+  * [[open|OPEN]]
+  * [[fetch|FETCH]]
+  * [[close|CLOSE]]

HPL/SQL - Procedural SQL on Hadoop, NoSQL and RDBMS