InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Define A Specific Record Type? |
|
Answer» If you WANT to define a specific RECORD type, you need to use the TYPE ... IS RECORD statement in the declaration PART of any procedure or FUNCTION. The following example script defines a RECORD type called STUDENT: CREATE OR REPLACE PROCEDURE HELLO AS TYPE student IS RECORD ( id NUMBER(5), first_name VARCHAR(80), last_name VARCHAR(80) ); BEGIN NULL; END; /If you want to define a specific RECORD type, you need to use the TYPE ... IS RECORD statement in the declaration part of any procedure or function. The following example script defines a RECORD type called STUDENT: |
|