IF Exists在Oracle中怎么用?


v_count NUMBER(2);

SELECT COUNT(*) INTO v_count FROM T_AAA;
IF v_count>0 THEN RETURN 1;
END IF;

RETURN 0;

posted @ 2010-12-20 10:58  RobotTech  阅读(2006)  评论(0编辑  收藏  举报