Re: insert values in table

On Thu, 18 Apr 2002 23:38:46 +0200, "de" <blada95_at_club-internet.fr> wrote:

>
>De: "de" <blada95_at_club-internet.fr>
>Objet: insert values in table
>Date : 18 avril 2002 23:04
>
>good morning every body
>
>i'm french so excuse my poor english
>
>here my question
>i'm new in oracle 8i i want to insert values in a table
>i don't want to insert line by line (insert into table values...))
>i want to know if someone have a script who can help me to insert 5 line in
>the same time in my table
>
>
>
insert into <table>
select <value1...>, value2,... value<n>
from dual
union
select <value1..>, value2..., value<n>
from dual
union
select <value1...>, value2,... value<n>
from dual
union
select <value1...>, value2,... value<n>
from dual
union
select <value1...>, value2,... value<n>
from dual
/

--
Regards


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address