摘要:
set serveroutput on declare pnum number :=1 ; begin while pnum10; dbms_output.put_line(pnum); pnum :=pnum+1; end loop; end; / set serveroutput on declare pnum number :=1 ; begin for pnum... 阅读全文
摘要:
set serveroutput on accept num prompt '请输入一个数字'; declare pnum number := # begin if pnum=0 then dbms_output.put_line('您输入的数据是0'); elsif pnum=1 then dbms_output.put_line('您输入的数据是1'); elsif ... 阅读全文
摘要:
set serveroutput on declare emplist emp%rowtype; begin select * into emplist from emp where empno=7839; dbms_output.put_line(emplist.ename||'的薪水是'||emplist.sal); end; / 阅读全文
摘要:
set serveroutput on 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; / 阅读全文