Define a Specific RECORD Type in Oracle

Q

How To Define a Specific RECORD Type in Oracle?

✍: FYIcenter.com

A

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;
/

 

Define a Variable for a Specific RECORD Type in Oracle

What Is a RECORD in PL/SQL in Oracle

Working with Database Objects in Oracle PL/SQL

⇑⇑ Oracle Database Tutorials

2018-09-01, 1420🔥, 0💬