Re: i want do some subqueries after INSERT

From: Jacques Desmazieres <jacques.desmazieres_at_is2france.com>
Date: 2000/07/07
Message-ID: <BEf95.449$795.1627231@nnrp2.proxad.net>#1/1

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_at_mdeo.fr> wrote in message news:3964D777.908578E9_at_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
>
>
Received on Fri Jul 07 2000 - 00:00:00 CDT