Solved

Need suggestion regarding query

Posted on 2008-09-29
3
171 Views
Last Modified: 2012-05-05
I have a column which is called "GPname which already has some data in it.

It is a varchar, Some of it has '-' in it. For eg: H-C corporation.
I need to make it as HC corporation

Please suggest the query for the table "corporations". Database is Oracle 10.0.
0
Comment
Question by:srikanthradix
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
Comment Utility
See if this helps:
(uses replace - http://www.techonthenet.com/oracle/functions/replace.php)
UPDATE corporations

SET GPname = Replace(GPname, '-', '')

Open in new window

0
 

Author Closing Comment

by:srikanthradix
Comment Utility
Actually, I was looking in thesaurus.com for synonyms for "excellent" and i found this "chef-d'oeuvre". Thanks.
0
 
LVL 59

Expert Comment

by:Kevin Cross
Comment Utility
>>chef-d'oeuvre
I like that. :)

You are most welcome.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now