擅长:python、mysql、java
<p>下面是检查条件并制作SCD-2的方块。也让我知道你到底在找什么。你知道吗</p>
<pre><code> BEGIN
LOOP cusrsor
SELECT COUNT(1)
INTO V_COUNT
FROM DIM table_name
WHERE <conditions here key columns and change fields here >
IF V_COUNT = 1 THEN update flag and insert new record
UPDATE stmt;
INSERT stmt;
ELSE New values to insert
INSERT stmt;
END IF;
END LOOP;
END;
</code></pre>