qq_35650979的博客

原创 控制结构

1. 条件分支语句 if语句 DECLARE in_var emp.sal%TYPE; BEGIN SELECT sal INTO in_var FROM emp WHERE empno=&out_var; IF(in_var<=2000)THEN dbms_output.put_line('in_var<=2000.'); ELSIF in_var2000