From: "Jacques Desmazieres" <jacques.desmazieres@is2france.com>
Subject: Re: i want do some subqueries after INSERT
Date: 2000/07/07
Message-ID: <BEf95.449$795.1627231@nnrp2.proxad.net>#1/1
References: <3964D777.908578E9@mdeo.fr>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@proxad.net
X-Trace: nnrp2.proxad.net 962954913 213.228.13.240 (Fri, 07 Jul 2000 09:28:33 CEST)
Organization: Guest of ProXad - France
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 09:28:33 CEST
Newsgroups: comp.databases.oracle.misc


INSERT INTO table1( truc, bidule)
SELECT c1, c2 FROM table2
WHERE id = xxx;

That all folks

Pour plus de détails, va voir dans la doc en ligne Oracle

Jacques

"damien" <lepage@mdeo.fr> wrote in message news:3964D777.908578E9@mdeo.fr...
> hi,
>
>
> i need to do that :
>
> insert into table1(bidule,machin) values (select bidule from table2
> where bidule='oracle','my oracle serveur');
>
>
> could you help me ???
>
> damien
>
>