Re: multi table insert ?

vertigo (ax178_at_wp.pl) wrote:
: 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 ?

This is not valid Oracle PL/SQL, but it might be valid in some other database system.

--

This space not for rent.