Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: multi table insert ?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US