pl/sql基本变量类型
declare
pnumber number(7,2);
pname varchar2(20);
pdate date;
begin
pnumber :=1;
dbms_output.put_line(pnumber);
pname :='tom';
dbms_output.put_line(pname);
pdate:=sysdate;
dbms_output.put_line(pdate);
dbms_output.put_line(pdate+1);
end;
引用型变量
declare
--定义姓名和薪水
pename emp.ename%type;--引用型变量
psal emp.sal%type;
begin
SELECT ename,sal into pename,psal from emp where empno = 7839;
dbms_output.put_line(pename||'的薪水是'||psal);
end;