Re: multi table insert ?

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 15 Feb 2005 11:04:00 -0800
Message-ID: <1108494240.353971.264560@o13g2000cwo.googlegroups.com>

No that is not a correct statement, because that INSERT... WHEN... syntax is not Standard SQL. It is not ORACLE SQL syntax either. I have no clue where you might find that it is valid. Are you sure it is not pseudocode??

If you want that functionality, then consider using the ORACLE SQL Loader. It is pretty good at loading data into multiple tables from the same input stream.

HTH,
ed Received on Tue Feb 15 2005 - 13:04:00 CST