Re: How can I insert multiple values in the same SQL command?

From: none <no_auto_reply_at_noreply.com>
Date: Thu, 15 Apr 1999 14:41:29 -0700
Message-ID: <7f5bju$htu$1@inet16.us.oracle.com>

INSERT INTO table_name(column1, column2, column3, column4, column5, column6)

VALUES (variable1, variable2, variable3, variable4, variable5, variable6);

Neil Robinson <vtr_at_firestorm996.freeserve.co.uk> wrote in message news:7f4bhd$upf$1_at_news6.svr.pol.co.uk...
> I need to insert as many as 10 records in one sql command. I've tried
> guessing at the correct syntax, but cannot do it. I'll be inserting data
> from variables rather than from another table, so I can't use the "INSERT
> ([fields]) VALUES (SELECT * FROM....) syntax either.
>
> Any help would be greatly appreciated.
>
> --
> Neil Robinson
>
>
Received on Thu Apr 15 1999 - 16:41:29 CDT