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 compatibility mode: SET ENVIRONMENT SQLMODE 'ORACLE'; Sample Data Setup CREATE TABLE testab ( id INT , name VARCHAR ( 20 ), sex VARCHAR ( 20 ), age INT ); INSERT INTO testab VALUES ( 101 , 'lisi' , 'female' , 18 ); INSERT INTO testab VALUES ( 102 , 'lisi' , 'female' , 18 ); INSERT INTO testab VALUES ( 103 , 'xiaowu' , 'male' , 19 ); CREATE TABLE tab1 AS SELECT * FROM testab WHERE 1 = 2 ; CREATE TABLE tab2 AS SELECT * FROM testab WHERE 1 = 2 ; Enter fullscreen mode Exit fullscreen mode Unconditional Insert ( INSERT ALL )…