insert multiple value

#1

hi

is it possible to do add the value returned by a requery in a field?

--create another field
alter table postes
add nblog integer

i would like to do something like

insert into postes(nblog)
select count (pos_n_poste)
from installers
where installers.pos_n_poste = postes.n_poste

is it possible?
--
Borland rulez http://pages.infinit.net/borland

#2

Try UPDATE instead of INSERT

"Marc Collin" <os2 (AT) videotron (DOT) ca> wrote

Quote:

hi

is it possible to do add the value returned by a requery in a field?

--create another field
alter table postes
add nblog integer

i would like to do something like

insert into postes(nblog)
select count (pos_n_poste)
from installers
where installers.pos_n_poste = postes.n_poste

is it possible?
--
Borland rulez http://pages.infinit.net/borland

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

insert multiple value

comp.database.oracle comp.database.oracle

insert multiple value - 02-21-2004 , 08:41 PM

Re: insert multiple value - 02-22-2004 , 09:28 PM