declare
NewShippers employee%rowtype;
begin
select *
into NewShippers
from employee
where emp_id = 1001;
dbms_output.put_line(NewShippers.emp_id);
end;
NewShippers employee%rowtype;
begin
select *
into NewShippers
from employee
where emp_id = 1001;
dbms_output.put_line(NewShippers.emp_id);
end;
mqmmx是物理表
ON COMMIT PRESERVE ROWS
as select * from authors;