Forum Stats

  • 3,767,857 Users
  • 2,252,726 Discussions
  • 7,874,365 Comments

Discussions

Create a composite type named DeptRecord ( iDeptno, sDeptName, sDeptLoc) as attributes with appropr

Albert Chao
Albert Chao Member Posts: 129 Green Ribbon
edited Sep 1, 2021 10:10AM in SQL Developer

SET SERVEROUTPUT ON;


DECLARE

  TYPE DEPTRECORD IS RECORD (

    IDEPTNO NUMBER := &deptno,

    SDEPTNAME VARCHAR2(150) := &deptname,

    SDEPTLOC VARCHAR2(150) := &deptloc

  );

  DEP_REC DEPTRECORD;

BEGIN

END;


Am confused whether I can directly write insert statement in between BEGIN & END? Plase advice

Answers