create table test2
(
empno number(10,2),
ename varchar2(10)
)
/
declare
abc test2%rowtype;
begin
abc.empno := 1;
abc.ename := '1';
dbms_output.put_line(abc.empno);
dbms_output.put_line(abc.ename);
end;
/
(
empno number(10,2),
ename varchar2(10)
)
/
declare
abc test2%rowtype;
begin
abc.empno := 1;
abc.ename := '1';
dbms_output.put_line(abc.empno);
dbms_output.put_line(abc.ename);
end;
/
16:41:47 2 abc test2%rowtype;
16:41:47 3 begin
16:41:47 4 abc.empno := 1;
16:41:47 5 abc.ename := '1';
16:41:47 6 dbms_output.put_line(abc.empno);
16:41:47 7 dbms_output.put_line(abc.ename);
16:41:47 8 end;
16:41:47 9 /
1
1PL/SQL 过程已成功完成。已用时间: 00: 00: 00.60
declare
abc test1%rowtype not null :=(1001,'smiths');但是不行,怎么办?
declare
abc test1.empno%type not null :=1001;