INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples

When you need to insert the same batch of data into multiple tables efficiently and consistently, GBASE's GBase 8s offers INSERT ALL and INSERT FIRST . They read the source table only once, eliminating the risk of data inconsistency that comes with running separate INSERT statements. Syntax Overview WHEN…THEN… : Can appear multiple times. INSERT FIRST acts on the first true WHEN and then stops; INSERT ALL continues evaluating and executing all subsequent true conditions. Requires Oracle compatib