|
Using PL/SQL Records In SQL Statements
By O'Reilly Network
Courtesy of O'Reilly
Article Date: 2003-04-22
A PL/SQL RECORD is a composite datatype. In contrast to a scalar datatype like NUMBER, a record is composed of multiple pieces of information, called fields. Records can be declared using relational tables or explicit cursors as "templates" with the %ROWTYPEdeclaration attribute.
You can also declare records based on TYPEs that you define yourself. Records are very handy constructs for PL/SQL developers.
Click below to read this article at the O'Reilly Web site:
http://www.oreillynet.com
About the Author:
The O'Reilly Network is the essential portal for developers interested in open and emerging technologies, including new platforms, programming languages, and operating systems. Just like O'Reilly & Associates' books, this hub site provides in-depth technical information, clearly and consistently, for expert developers. Beyond that, it creates a forum for the O'Reilly developer community, giving them the chance to interact both with each other and independent affiliate sites. A primary aim is to help developers cross over into new technical communities, which is essential for their professional development and personal satisfaction.
|
|
