IF语句的使用
A.基本的IF条件语句:
基本语法:
![程序代码](http://www.dezai.cn/blog/images/code.gif)
IF THEN
END IF;
或
if a=... then ......... end if;Example:
![程序代码](http://www.dezai.cn/blog/images/code.gif)
SQL> set serveroutput on;
SQL> declare
x number(3):=9;
begin
if x<10 then
dbms_output.put_line('x is less than10');
end if;
end;
结果:
x is less than10
B.IF - ELSE 语句
基本语法:
![程序代码](http://www.dezai.cn/blog/images/code.gif)
IF THEN
ELSE
END IF;
或
if a=... then ...... else .... end ifExample:Example:DECLARE x NUMBER(3) := 10; BEGIN IF x < 10 THEN dbms_output.put_line('X is less than 10'); ELSE dbms_output.put_line('X is not less than 10'); END IF; END; 结果: X is not less than 10 C:IF - ELSIF - ELSE 语句 基本语法:程序代码
IF THEN程序代码
ELSIF THEN
ELSIF THEN
ELSE
END IF;
if a=.. then ...... elsif a=.. then .... end if; 这里中间是“ELSIF”,而不是ELSE IF 。这里需要特别注意
![程序代码](http://www.dezai.cn/blog/images/code.gif)
set serveroutput on
DECLARE
x NUMBER(3) := 47;
BEGIN
IF x < 10 THEN
dbms_output.put_line('X is less than 10');
ELSIF x = 10 THEN
dbms_output.put_line('X is equal to 10');
ELSIF x < 100 THEN
dbms_output.put_line('X is between 11 and 99');
ELSE
dbms_output.put_line('X is greater than 99');
END IF;
END;
/
结果:
X is between 11 and 99