Re: Database Queries (gurus - Help needed)
From: Michael Ryan <ryan>
Date: 1995/08/22
Message-ID: <1995Aug22.013823.25824_at_xsoft.uucp>#1/1
joseph
ingrid
jose
seph
grid
se
Date: 1995/08/22
Message-ID: <1995Aug22.013823.25824_at_xsoft.uucp>#1/1
RTFM. UPDATE <your table> SET <your column> = SUBSTR ( <your column> , 3 );
E.g., using table tn ( varchar2 ( 10 ) ):
SQL> select * from tn;
NAME
joseph
ingrid
jose
SQL> update tn set name = substr ( name , 3 );
3 rows updated.
SQL> select * from tn;
NAME
seph
grid
se
//michael
--Received on Tue Aug 22 1995 - 00:00:00 CEST
:: michael ryan , ryan_at_xsoft.xerox.com
:: ob disclaimer: opinions expressed are not those of xerox, corp.