Re: Inserting multiple rows with one INSERT statement

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 2 Jul 1999 12:09:55 +0100
Message-ID: <930914195.17032.1.nnrp-09.9e984b29@news.demon.co.uk>

Put the 'rows' into an array type
then cast the array into a cursor

Look on my website for the DUMMY DATA
article as an indication on how to do this, also my recent post on 'Top 10 in Oracle 8'.

NB Not applicable to version 7

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Matt Randle wrote in message
<930910772.12204.0.nnrp-03.d4e48d0d_at_news.demon.co.uk>...
>Sorry, I should have made it clear. I meant can you insert multiple rows
>from a set of constants (not another Oracle table).
Received on Fri Jul 02 1999 - 06:09:55 CDT