Home » RDBMS Server » Server Utilities » concatiating a string with a field in sql
concatiating a string with a field in sql [message #69593] Tue, 05 February 2002 10:07 Go to next message
Rob
Messages: 70
Registered: January 2000
Member
how would you go about running an update a field like this in oracle sql
update table
set col1 = so col1 will be 00 + col1
Re: concatiating a string with a field in sql [message #69600 is a reply to message #69593] Wed, 06 February 2002 06:09 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
update table
set col1 = '00' || col1
Previous Topic: Re: Import txt file to Oracle SQL* Plus
Next Topic: Re: oracle - export
Goto Forum:
  


Current Time: Fri Mar 29 05:38:03 CDT 2024