Re: Database Queries (gurus - Help needed)

Zsan (zsan_at_netcom.com) wrote:
> Could someone help me with a sql database query?
 

> To present a simplified version of the problem, I want to be able to
> do a query to delete the first 2 characters of a field.
 

> Example:
 

> Name
> ----
> joseph
> ingrid
> jose

> then after the query, the result would be:
 

> Name:
> ---
> seph
> grid
> se

Hi , you must do an update instead of a delete , something like :

upadre table T set fila1=substr(fila1,3) where <id_fila>

chau.
e-mail :jperez_at_cl.oracle.com   Received on Thu Aug 17 1995 - 00:00:00 CEST