Sunday, February 21, 2016

Best way to do multi-row insert in Oracle

Best way to do multi-row insert in Oracle


sample code


insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE) select 8000,0,'Multi 8000',1 from dual
union all select 8001,0,'Multi 8001',1 from dual

No comments:

Post a Comment

Comments system

Disqus Shortname

Disqus Shortname

Comments system