摘要:
--使用while循环打印数字1~10declare 2 pnum number :=1; 3 begin 4 while pnum <=10 loop 5 dbms_output.put_line(pnum); 6 pnum := pnum+1;-- 注意:pnum++在PL/SQL中不成立 7 阅读全文
摘要:
set serveroutput on;--引用型变量declare 2 pname emp.ename%type; 3 psal emp.sal%type; 4 begin 5 select ename,sal into pname,psal from emp 6 where empno=7844 阅读全文