| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> multi table insert ?
Hello
INSERT INTO ALL WHEN DEPT_NO IN (12,14) THEN INTO EMP SELECT * FROM EMP_OLD;
Is it correct statemant ?
I think it's not (without first INTO it is ok), but i found somewhere
that it is.
Could anybody explain why ?
Thanx
Michal
Received on Tue Feb 15 2005 - 04:02:52 CST
 |
 |