Software dev. tips and tricks
Thursday, January 7, 2010
SQL INSERT from SELECT or SEQUENCE - Oracle
insert
into tab1(a, b, c, d, e)
SELECT a1, b1, c1, d1, 'ABC' AS e1
FROM tab2 t2
WHERE t2.d1 = 'x';
insert
into emp
(
empno
)
values
(
mySeq.nextVal
)
;
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2013
(1)
►
May
(1)
►
2012
(2)
►
December
(2)
▼
2010
(1)
▼
January
(1)
SQL INSERT from SELECT or SEQUENCE - Oracle
No comments:
Post a Comment