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