Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Retrieve Data from an Cursor to a RECORD
How To Retrieve Data from an Cursor to a RECORD? - Oracle DBA FAQ - Working with Cursors in PL/SQL
✍: FYIcenter.com
If you have a cursor opened ready to use, you can also use the FETCH statement to retrieve data from the cursor into a RECORD variable as shown in the tutorial exercise below:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR t_list IS SELECT first_name, last_name FROM employees; TYPE name_rec IS RECORD ( f_name VARCHAR2(10), l_name VARCHAR2(10) ); n name_rec; BEGIN OPEN t_list; FETCH t_list INTO n; DBMS_OUTPUT.PUT_LINE('Name = ' || n.f_name || ' ' || n.l_name); FETCH t_list INTO n; DBMS_OUTPUT.PUT_LINE('Name = ' || n.f_name || ' ' || n.l_name); CLOSE t_list; END; / Name = Ellen Abel Name = Sundar Ande
2007-04-29, 4724👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int a=0; if (a==0) printf("Cisco...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
Is XHTML Element Name Case Sensitive? - XHTML Tutorials - Introduction To Tag and Attribute Syntax Y...
What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...
What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...