if...else...条件选择结构。
oracle 流程控制语句
标签：ora exec logs name rom 选择 exe iat imm
oracle 流程控制语句
CNT PLS_INTEGER;
BEGIN
SELECT COUNT (*) FCOUNT
INTO CNT
FROM (SELECT 1
FROM USER_TAB_COLUMNS
WHERE ( TABLE_NAME = ‘{0}‘
AND COLUMN_NAME = ‘FCKJF‘)
AND ROWNUM <= 1);
IF CNT > 0
THEN
EXECUTE IMMEDIATE
‘UPDATE {0}
SET FFOUNDORSTOCKCOST = FFOUNDORSTOCKCOST + nvl(FCKJF,0)‘;
END IF;
END;