Re: Update

From: Mark Gourley <mark_gourley_at_hotmail.com>
Date: Fri, 25 Sep 1998 11:35:02 +0100
Message-ID: <360B71D6.D3B4497@hotmail.com>

This should do the trick...

UPDATE <TABLE>
SET WRK_SB_NO = '19' || WRK_SB_NO; Mark.

speng_at_ncs.com.sg wrote:

> I have a table which contains 8000 records and one of the column is a varchar2
> datatypes. For example, the column_name is wrk_sb_no and the value is
> '9807060105'. Is there any way to insert a '19' to this value in front and
> appear as '199807060105'. I need to update the 8000 record at the time.
>
> --
> Sok Peng
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 25 1998 - 05:35:02 CDT