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: update email address

Re: update email address

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 5 Apr 2005 15:17:33 -0800
Message-ID: <42530e7d@news.victoria.tc.ca>


HansF (News.Hans_at_telus.net) wrote:
: On Tue, 05 Apr 2005 13:55:02 -0700, Sheela interested us by writing:

: > update student a set
: > substr(a.email_addr,(instr(a.email_addr,'@')+1),10) = 'yyyyy.com'where

: Basically the SET clause requires a column on the left side immediately
: after the 'set', but you seem to have a wild expression in place of the
: column name.  (Nor does your statement meet any of the other variations
: permitted.)

It looks like valid perl to update a portion of a string. I suspect the poster has "losing track of multiple contexts" syndrome.

--

This space not for rent.
Received on Tue Apr 05 2005 - 18:17:33 CDT

Original text of this message

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