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 -> Re: question about set statement

Re: question about set statement

From: jAnO! <j.j.groot_at_kpn.com>
Date: 23 Aug 2001 12:45:09 GMT
Message-ID: <01c12bd1$7175a860$532b15ac@TONTW0108082044> 







Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com> schreef in artikel
<3B84F6D9.A85DF0FA_at_hollomey.com>...


> update tablename set ASN_PULS_CODE = lpad(to_number(ASN_PULS_CODE),3,'0')

> 

> or as Xavier suggested:

> 

> update tablename set ASN_PULS_CODE = lpad(rtrim(ASN_PULS_CODE),3,'0')

> 

> 



works like a charm, thanks guys..
Received on Thu Aug 23 2001 - 07:45:09 CDT












Original text of this message













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