PLSQL 各种能用到的语句
set serveroutput on;
DECLARE
test_number NUMBER:=10;
BEGIN
CASE test_number
WHEN 10 THEN
goto seconds;
DBMS_OUTPUT.PUT_LINE('10');
WHEN 20 THEN
DBMS_OUTPUT.PUT_LINE('20');
ELSE
DBMS_OUTPUT.PUT_LINE('40');
END CASE;
<<seconds>> --这里不能在CASE里面自由跳动
DBMS_OUTPUT.PUT_LINE('40');
END;wm_concat()
---------------------------------------------------------------------------------
Kind Regards,
HaiTao Niu
JavaScript developer :)
ORACLE Certified Database Administrator - 10g
SUN Certified Applocation Developer - Java 6
Ring Building,No.28,ZhongGuanCun Software Park, No.8 Dong Bei Wang West Road, Haidian District, Beijing P.R.China 100193
E-mail: 1648500@qq.com
浙公网安备 33010602011771号