-- inserting multiple rows at a time by sIngle querry
insert all
when 1=1 then into month(dt, val)
select '11-JAN-2011' dt , 5 val from dual
union all
select '11-JAN-2011' dt , 7 val from dual
union all
select '11-JAN-2011' dt , 9 val from dual
union all
select '1-JAN-2011' dt , 10 val from dual
No comments:
Post a Comment