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

Home -> Community -> Usenet -> c.d.o.server -> Re: Understanding TRUNC in SELECT/UPDATE

Re: Understanding TRUNC in SELECT/UPDATE

From: Alien <stijf_at_stijf.com>
Date: 24 Feb 2006 06:18:52 -0800
Message-ID: <1140790732.504540.284030@p10g2000cwp.googlegroups.com> 





Hi,



You can't combine a subquery and a mathematical function. Try:
UPDATE TEST A SET DAYSTONEXTDATE = TRUNC((SELECT

MIN(STARTDATE)-TRUNC(A.STARTDATE) FROM TEST

WHERE STARTDATE > A.STARTDATE)) - TRUNC(A.STARTDATE); 



Regards,



Arian
Received on Fri Feb 24 2006 - 08:18:52 CST












Original text of this message













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