1、變量賦值 Oracle: i := 1; db2: set i = 1;2、For循環(huán) 1）案例1： oracle: FOR I IN SQL LOOP ..... END LOOP; db2: FOR I AS SQL DO ..... END FOR; 2）案例2： oracle: FOR I IN 1..3 LOOP ..... END LOOP; db2: SET I = 1; WHILE I <= 3 DO ..... SET I = I + 1; END WHILE;3、IF語句 oracle: IF .. THEN .. ELSIF .. THEN .. ELSE .. END IF; db2: IF .. THEN .. ELSEIF .. THEN .. ELSE .. END IF;4、動態(tài)執(zhí)行SQL語句 1）案例1： oracle: EXECUTE IMMEDIATE MySQL INTO v_num; db2: VALUES mySQL INTO v_num; 2）案例2： oracle: EXECUTE IMMEDIATE mySQL db2: PREPARE S1 FROM mySQL; EXECUTE S1;5、虛擬表 oracle：DUAL db2： SYSIBM.SYSDUMMY1或SYSIBM.DUAL或VALUES 例如：SELECT '12345' FROM SYSIBM.DUAL VALUES '12345'6、oracle、db2都存在TO_CHAR、TO_DATE、SYSDATE7、查詢數(shù)據(jù)庫中存儲過程：SELECT * FROM SYSCAT.PROCEDURES
