declare
v_a number;
v_b number;
v_c number;
v_sql varchar2(1000);
v_username varchar2(10);
v_password varchar2(10);
begin
v_a := 5;
if v_a < 10 then
dbms_output.put_line('a小于10');
end if;
--2层结构
v_b := 5;
if v_b < 10 then
dbms_output.put_line('b小于10');
else
dbms_output.put_line('b大于10');
end if;
v_c := 25;
if v_c < 10 then
dbms_output.put_line('b小于10');
elsif v_c > 10 and v_c < 20 then
dbms_output.put_line('b大于10');
else
dbms_output.put_line('c大于20');
end if;
--SQL语句的拼凑
v_username := 'a';
v_password := '123456';
v_sql := 'Select * From T_Userinfo where 1 = 1';
if v_username is not null and v_username != ' ' then
v_sql := v_sql || ' and username like ''%' || v_username ||
'%'' ';
end if;
if v_password is not null and v_password != ' ' then
v_sql := v_sql || ' and password = ''';
v_sql := v_sql || v_password;
v_sql := v_sql || '''';
end if;
v_sql := v_sql || ' order by userid asc';
dbms_output.put_line(v_sql);
end;
--Select * From T_Userinfo where 1 = 1 and username like '%a%'
--and password = '123456' order by userid asc