OraFAQ Forum: Server Administration » Use SQL*Plus to update a part of a string or value

Home » RDBMS Server » Server Administration » Use SQL*Plus to update a part of a string or value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Use SQL*Plus to update a part of a string or value [message #375066]

Mon, 23 July 2001 10:06

Jalbah
Messages: 2
Registered: July 2001

Junior Member

I need to change the area codes for several records in an Oracle database. I tried the following:

update customer
set substr(phone,1,3) = "913"
where custID = '123456';

and I got an error saying that there was no "=" after substr. Anyone tell me the correct syntax, please?

Report message to a moderator

Re: Use SQL*Plus to update a part of a string or value [message #375103 is a reply to message #375066]

Thu, 26 July 2001 05:08

Jalbah
Messages: 2
Registered: July 2001

Junior Member

Thanks! That works great!

Report message to a moderator

Previous Topic:	Re: PL/SQL Positions in Richmond, VA and Virginia Beach
Next Topic:	Re: SQL Server 7 statement to Oracle 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 06:57:47 CST 2024