UPDATE table_name SET wrk_sb_no='19' || wrk_sb_no;
engpeng_at_my-dejanews.com wrote in article
<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 Thu Oct 01 1998 - 05:28:31 CDT
