oracle 流程控制语句
时间：2021-07-01 10:21:17
帮助过：15人阅读
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;
if...else...条件选择结构。
oracle 流程控制语句
标签：ora exec logs name rom 选择 exe iat imm
