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
Post a Comment