Oracle SQL - How can I write an insert statement that is conditional and looped? -

context: have 2 tables: markettypewagerlimitgroups (mtwlg) , stakedistributionindicators (sdi). when mtwlg created, 2 rows created in sdi table linked mtwlg - each row same values bar 2, id , field (let's call column x) must contain 0 1 row , 1 other. there bug present in our codebase prevented happening automatically, mtwlg's created during time bug present not have related sdi's, causing npe's in various places.

to fix this, patch needs written loop through mtwlg table , each id, search sdi table 2 related rows. if rows present, nothing; if there 1 row, check if f 0 or 1, , insert row other value; if neither row present, insert them both. needs done every mtwlg, , unique id needs inserted too.

pseudocode:

for each market type wager limit group id     check if there 2 rows id in stake distributions table, 1 column x = 0 , 1 column x = 1     if none         create 2 rows in stake distributions table unique id's; 1 each x value     if 1         create missing row in stake distributions table unique id     if 2         nothing 

if helps @ - patch applied using liquibase.

anyone advice or thoughts if , how possible write in sql/a liquibase patch?

thanks in advance, let me know of other information need.

edit:

i've been advised using pl/sql, have thoughts/suggestions in regards this? again.

oooooh, excellent job merge.

here's pseudo code again:

for each market type wager limit group id     check if there 2 rows id in stake distributions table,         1 column x = 0 , 1 column x = 1     if none         create 2 rows in stake distributions table unique id's;          1 each x value     if 1         create missing row in stake distributions table unique id     if 2         nothing 

here's merge variant (still pseudo-code'ish don't know how data looks):

merge stake_distributions d using (   select limit_group_id, 0 x   market_type_wagers   union   select limit_group_id, 1 x   market_type_wagers ) t on (   d.limit_group_id = t.limit_group_id , d.x = t.x ) when not matched insert (d.limit_group_id, d.x) values (t.limit_group_id, t.x); 

no loops, no pl/sql, no conditional statements, plain beautiful sql.

nice alternative suggested boneist in comments uses cross join rather union all in using clause, likely perform better (unverified):

merge stake_distributions d using (   select w.limit_group_id, x.x   market_type_wagers w   cross join (     select 0 x dual     union     select 1 x dual   ) x ) t on (   d.limit_group_id = t.limit_group_id , d.x = t.x ) when not matched insert (d.limit_group_id, d.x) values (t.limit_group_id, t.x);