oracle 流程式控制制語句

標籤：ora   exec   logs   name   rom   選擇   exe   iat   imm   

DECLARE                                                               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 流程式控制制語句