how i insert churned rows seer method value?


i know i insert churned rows controlling unparalleled statement, i syntax .



however, values i am inserting taken sequence, i.e.



insert table_name
(col1,col2)
select my_seq.nextval,'some value' dual
union all
select my_seq.nextval,'another value' dual
;


if i try run it, i an ora-02287 error. there any proceed around this, should i only lot insert statements?



edit:

if i have mention buttress names columns sequence, i remove uncanny brevity, it's only value it. box i'll only churned insert statements.



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?