Home » SQL & PL/SQL » SQL & PL/SQL » SQL update script help
SQL update script help [message #20053] Fri, 26 April 2002 11:29
Arpit
Messages: 99
Registered: March 2001
Member
Hello ,

Can someone help me with this udpate script.

I need to update my phone_no data in the employee table from +1 (416) 666-6666 to (416) 666-6666.

I need to get rid of +1 along with a empty space after it for all phone no records.

Any help on this would be highly appreciated.

Thanks!

Report message to a moderator

Previous Topic: ORA-06502, ORA-06512 and pad string errors
Next Topic: Re: how to retrieve top 3 salaries
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:42:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.