Re: Help! PL/SQL Query

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Mon, 15 Nov 1999 16:25:20 GMT
Message-ID: <80pc59$7rs$1@nnrp1.deja.com>

i guess, you may not need a PL/SQL to do this.

try this.

update table_a
set column_a=ltrim(column_a,'*')
;

regards

In article <80pa4h$61e$1_at_nnrp1.deja.com>, sjoshi_at_ingr.com wrote:
> Hello All
> I have table with a column called name. Now some of the name have
> *** in front of them. I was wondering if someone can tell me how to
> write a PL/SQL statement that will remove the *** from the name fields
>
> thanks
> Sunit
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Nandakumar

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 15 1999 - 10:25:20 CST