Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Define a Variable of a Specific RECORD Type
How To Define a Variable of a Specific RECORD Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL
✍: FYIcenter.com
Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defined with a regular data type and a specific RECORD type:
CREATE OR REPLACE PROCEDURE HELLO AS TYPE student IS RECORD ( id NUMBER(5), first_name VARCHAR(80), last_name VARCHAR(80) ); best_student student; another_student student; class_name VARCHAR2(80); BEGIN NULL; END; /
2007-04-27, 4494👍, 0💬
Popular Posts:
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...
How do you handle change request? Normally change request are handled by preparing an Impact analysi...
What is the difference between Authentication and authorization? This can be a tricky question. Thes...
What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...