Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: a join between tables and a 'selective' update

Re: a join between tables and a 'selective' update

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 20 Jan 2005 07:08:28 -0800
Message-ID: <1106233708.587774.204640@c13g2000cwb.googlegroups.com> 





>> All that was needed was '= ANY' instead of 'IN' operator, since

'ANY'  *allows* for multiple column output from SELECT, ..<<



That is weird -- the Standard defines "IN()" as "=ANY()".  Most SQL
products do not have row constructors yet, which is a serious problem.
Received on Thu Jan 20 2005 - 09:08:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US