Re: Update

From: Kurt Laugesen <kul_at_post3.tele.dk>
Date: Fri, 25 Sep 1998 11:19:38 +0200
Message-ID: <6ufn41$1reu$1@news-inn.inet.tele.dk>

update <tablename> set wrk_sb_no = '19'||wrk_sb_no ;

this should do the trick.
Regards
Kurt

engpeng_at_my-dejanews.com wrote in message <6ufl8k$epo$1_at_nnrp1.dejanews.com>...
>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.
>
>
>-----== 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 - 04:19:38 CDT