Re: (SQL) UPDATING a table from a join

> The "best" way to do this would be to use PL*SQL. This works only if you
> have the procedural option installed. The join would be performed by
> the cursor and the update is performed in the PL*SQL block.
> The performance of this will depend on the presence (or absence) of
> appropriate indexes.

This is an interesting option. I must admit that I have a preconception which pushes me to look first at "pure" SQL requests, but your solution makes sense.

Thanks very much for your help.

Best regards

Emmanuel Baechler
Lausanne
Switzerland Received on Fri Jun 12 1998 - 09:31:37 CEST