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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Better Way around the barn

Re: Better Way around the barn

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Jul 2005 10:02:03 -0700
Message-ID: <1120669348.334112@yasure>


harvey.jim_at_gmail.com wrote:
> Is ther a better way to do this?
>
> //Code
>
> UPDATE JDE_INBOUNDRIP
> SET JDE_INBOUNDRIP.ITEMNUMBER = (SELECT
> ltrim(JDE_INBOUNDRIP.ITEMNUMBER) FROM JDE_INBOUNDRIP WHERE
> JDE_INBOUNDRIP.ITEMNUMBER LIKE ' 5%')
> WHERE JDE_INBOUNDRIP.ITEMNUMBER LIKE ' 5%'
>
>
> //End Code
>
> Thanks Jim

  1. Oracle version
  2. Explain plan
  3. DDL
Tried to look over your shoulder but the potted plant was in the way.
-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Jul 06 2005 - 12:02:03 CDT

Original text of this message

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