Re: multiple inserts in a single sql statement

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Mon, 15 Mar 99 21:45:29 GMT
Message-ID: <7cjupo$8qe$1@news.doit.wisc.edu>

Alternatively:

        insert
        into    <table>
        (
                <column 1>


        ,       <column 2>


        ,       ...
        )
        select  <value 1>


        ,       <value 2>


        ,       ...
        from    DUAL
        union   all
        select  <value 1>


        ,       <value 2>


        ,       ...
        from    DUAL
        union   all
        ...

G.

---

Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Mon Mar 15 1999 - 15:45:29 CST