Oracle PLSQL Tutorial Cursor 131 codes

  1. Home
  2. Oracle PLSQL Tutorial
  3. Cursor
1 %ISOPEN, %FOUND, %NOTFOUND variables arent useful at all in CURSOR FOR loops
2 A complete example of using SELECT FOR UPDATE cursors
3 A complete example of using the cursorValue cursor
4 A Cursor for counting
5 A loop is required is to read each row in cursor returned
6 A PLSQL function that uses a cursor expression
7 Accessing Status Info by Using Cursor Variables
8 Adding an Exception Handler to a CURSOR FOR Loop
9 An example of cursor variable assignment
10 An example of cursor variable using %ROWCOUNT
11 An example of cursorValue cursor using %ISOPEN
12 An example of opening a cursor variable
13 An example of opening the cursorValue cursor
14 An example of parameterized cursor using cursor FOR LOOP
15 An example of using SYS_REFCURSOR for cursor variable processing
16 An example to illustrate parameterized cursors and cursorValue%NOTFOUND
17 Assigning different queries to the same cursor variable
18 Check error code and Raise the proper error
19 Check sql%rowcount
20 Checking the status of explicit cursors
21 Checking the status of implicit cursors
22 Close a cursor
23 Close cursor after while loop
24 Close cursor in excpetion handler
25 Compare the performance differences between row-at-a-time processing and bulk processing
26 Correct Code to Exit a Loop
27 Correctly Written Explicit Cursors
28 Create a cursor for update
29 Create and use reference cursor
30 Creating a REF CURSOR datatype
31 Cursor bulk
32 Cursor expressions as arguments to functions called from SQL
33 Cursor expressions using multiple levels of nested cursors
34 Cursor for aggregate function
35 Cursor FOR Loop
36 Cursor for object table
37 Cursor for update
38 Cursor FOR UPDATE NOWAIT
39 Cursor function
40 Cursor not found
41 Cursor performance
42 Cursor rowid
43 Cursor to reference whole table
44 Cursor with order by
45 Cursors
46 Declare and use a cursor in for loop
47 Declare cursor
48 Declaring a Cursor within a Procedure
49 Define refcursor variable
50 Defining a Cursor in an Anonymous PLSQL Block
51 Defining a Record Type for a Cursor by Using %ROWTYPE
52 Defining cursors in the package body
53 Defining cursors in the package specification
54 Exit a LOOP when cursor%NOTFOUND
55 Explicit cursor with cursor variable
56 Fetch cursor till cursorName%NOTFOUND
57 Fetch cursor till notfound
58 Fetch cursor to table collection of row type
59 Fetch cursor to three variables
60 Fetch cursor value into column type variable
61 Fetch cursor value to three variables
62 Fetch data into PLSQL table
63 Fetch row by row
64 Fetching Across Commits
65 Fetching Across Commits, Example 2
66 First Cursor Example
67 For data in ( select from tableName )
68 Handling exceptions in implicit cursors
69 Implicit Cursor
70 Implicit Cursor Attributes
71 Implicit Cursor Attributes Example
72 Implicit cursor open, fetch and close
73 Knowing what record is processing
74 LOOP END LOOP Cursor Loop
75 Loop till exit when cursorName%notfound
76 Looping through a Cursor by Using the LOOP Command
77 Nested cursor
78 Nested cursor open
79 NO_DATA_FOUND Exception vs %NOTFOUND
80 OPEN Cursor for fetching
81 Open cursor with a dynamic select statement
82 Open cursor with parameter
83 Open SYS_REFCURSOR for select from
84 Opening multiple queries using the same cursor variable
85 Output value in a refcursor
86 Parameterized cursor
87 Passing data from one table function to another in a pipelined fashion
88 Passing parameters to cursors
89 Placing cursors in nested loops
90 Populating a Record with FETCH INTO
91 Raise no data found exception if cursor is empty
92 REF CURSOR custom type
93 Reference cursor
94 Reference cursor type
95 Reference cursor variable
96 Reference value in a cursor by cursor variable
97 Return information using cursor status variables
98 Return sys_refcursor from a function
99 Returning an implicit cursor into a record
100 Returning more than one piece of information
101 Row type Reference cursor
102 Select column value into a cursor variable
103 Select first row to a cursor
104 Sql%notfound
105 Subprograms returning resultsets by using SYS_REFCURSOR
106 SYS_REFCURSOR as parameter
107 SYS_REFCURSOR type parameter
108 Taking a Shortcut with CURSOR FOR Loops
109 Test cursor attributes with an implicit cursor
110 The Difference between Explicit and Implicit Cursors
111 The use of REF CURSOR
112 Timing a ref cursor
113 To determine when the loop is to end, you can use the Boolean variable cursorName%NOTFOUND
114 To lock all the records while youre working on them This is done using a SELECT FOR UPDATE command
115 To prepare the comma-separated list
116 Use %ROWCOUNT to detect what record you are processing at a given point
117 Use cursor variables
118 Use explicit cursor to fetch and store value to number variable
119 Use For loop to output data in a PLSQL table of cursor
120 Use implicit or explicit cursor to insert 50000 rows to a table
121 Use the cursor subquery
122 Using %ROWCOUNT as an incremental rowcount
123 Using a simple UPDATE statement without locking for rows fetched from Cursors
124 Using SELECT in a Cursor
125 Using SQL%BULK_ROWCOUNT and SQL%ROWCOUNT
126 Using WHERE CURRENT OF
127 VARRAY of Cursor
128 When cursorName%NOTFOUND
129 WHILE LOOP Cursor Loop
130 While cursorName%found, loop
131 While cursorVariable%found loop