PL\SQL基础(三)

PL/SQL中sql语句
declare
   tmpname emp.ename%type;
   tmpsal  emp.sal%type;
begin
   select ename,sal into tmpname,tmpsal from emp where empno=8321;
   dbms_output.put_line(tmpname||' '||tmpsal);
end;
或者使用rowtype简化
declare
   tmpemp emp%rowtype;
begin
   select *  into tmpemp from emp where empno=8321;
   dbms_output.put_line(tmpemp.ename);
end;
inset,update之类一样
declare
   tmpno dept.no%rowtype :=40;
   tmpname dept.name%type :='tom';
   tmploc dept.loc%type :='nj';
begin
    insert into dept1 values(tmpno,tmpname,tmploc);
commit;
end;