Multitable Insert

So, let’s start with two normal inserts:

insert into tab1
select 1,1,’first’ from dual

and

insert into tab2
select 1,1,’first’ from dual

this work fine, but we got Oracle 9 and 10 nowadays so we can:

Insert all
into tab1
into tab2
select 1,1,’first’ from dual

and this give us:
ORA-00918: column ambiguously defined

A bit strange.