申请入会之Oracel条件判断

前言：
申请入会的时候需要先判断有没有，然后再决定插不插入，这里需要用到Oracle条件判断的技术点

参考文献:

http://blog.leanote.com/post/yuanquan.ni@qq.com/Oracle-IF-ELSE-条件判断结构
https://www.2cto.com/database/201804/739260.html
https://stackoverflow.com/questions/12934680/plsql-stored-procedure-pls-00103-encounterd-the-symbol-select

一个简单的示例

   declare 
   x number(3):=9;
    begin
    if x<10 then
    dbms_output.put_line('x is less than10');
    end if;
   end;

GH版本：《值得注意的是 select into语句》

declare 
a number(3):=1;
BEGIN
select count(*) into a from bi_trade_apply where apply_id='123';
IF  a=0 THEN  
INSERT INTO "WHGH"."BI_TRADE_INFO" ("ACCOUNT", "NAME", "SEX", "BIRTHDAY", "POLITICAL_STATUS", "NATION", "EMAIL", "CARD_TYPE", "CARD_NO", "QUALIFICATIONS", "DEGREE", "POST", "DUTIES", "MEMO", "INTRADE_DATE", "LEAGUER_NO", "LEAGUER_TYPE", "DEPT_ID", "TELE_PHONE", "TRADE_STATUS", "TRADE_MEMO") VALUES ('ly', 'wtt', '0', TO_DATE('1992-08-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '3', '汉族', '1922919XXXX@qq.com', '1', '426xxxxxxxxxxxxx49', '2', '2', '无岗位', '无职称', '测试备注1', TO_DATE('2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '26', '180xxxxxx96', '1', NULL);

ELSE  
update bi_trade_info set trade_status=1 where account=(select account from bi_trade_apply where apply_id='123');

END IF;
END;