Tuesday, May 24, 2011

INSERT MULTIPLE ROWS USING SINGLE QUERRY

-- 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