词穷墨尽博客

declare i varchar2(10) := '张三'; begin dbms_output.put_line(i);end;declare i emp.sal%type; begin select sal into i from emp where empno = 7369; dbms_output.put_line(i);end;d...

declare -- 创建一个游标 cursor emps is select * from emp; -- 声明一个变量记录数据 em emp%rowtype; begin -- 打开游标 open emps; --循环读取数据 loop fetch emps into em; -- 当 游标为空时退出循环 ...

declare i number; em emp%rowtype; begin -- i:=8/0; -- i='aaaa'; -- select * into em from emp; select * into em from emp where empno=1234567; exception when zero_divid e th...