Re: SQL. Correlated UPDATE problem.

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 3 Feb 2000 15:01:36 +0100
Message-ID: <87c1o1$1g39$1@news6.isdnet.net>

In Oracle8i 8.1.5, you'll find this in on-line page <ORACLE_HOME>\doc\server.815\a67779\ch4m.htm

Note that Update statement is:
update [<hint<] <table_expression_clause> <set_clause> [<where_clause>]...

and <table_expression_clause> may be (among other things): (<subquery> [<with_clause>])

--
Michel

Ivan Nilsson <dumb_at_nospam.com> a écrit dans le message : cGcm4.4529$jg4.9101_at_nntpserver.swip.net... Thanks alot!

I couldb't find this on reading the UPDATE section of the Oracle SQL Reference documentation (version 8i enterprise). It's odd they doesn't mention this way of getting the job done (or perhaps I am not a very observant reader?) Received on Thu Feb 03 2000 - 08:01:36 CST