使用oracle写if判断

DECLARE
  L_X INT;
BEGIN
  SELECT COUNT(*) INTO L_X FROM SYSTEMROLEFUNCTION WHERE ROLEID = '1';
  IF L_X > 0 THEN
    INSERT INTO SYSTEMROLEFUNCTION
      (FUNCTIONID, ROLEID)
    VALUES
      ('123', '1');
  END IF;
  COMMIT;
END;

 

posted @ 2014-12-18 14:43  临冰听雪丶  阅读(1118)  评论(1)    收藏  举报