Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Update

Update

From: <engpeng_at_my-dejanews.com>
Date: Fri, 25 Sep 1998 08:46:12 GMT
Message-ID: <6ufl8k$epo$1@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 - 03:46:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US