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