接受用户输入部门编号,部门名称,部门地址,插入到SCOTT.DEPT表中

declare
 D_deptno dept%rowtype;

begin
 D_deptno.deptno:=&D_deptno;
 D_deptno.dname:='&D_dname';
 D_deptno.loc:='&D_loc';
  execute immediate 'insert into dept values(:1,:2,:3)' using  D_deptno.deptno,D_deptno.dname,D_deptno.loc;
 end;
/