 |
Experts on Demand
I am a user of Oracle 9i on Unix, and I'm creating a temporary table. One of the columns I want to use is a varchar2 (40) type, and each row currently has a $ sign somewhere in the string. The placement of the $ sign is random and the length of the string varies from 12 to 39 alpha numeric and symbols. When I include this column in the temporary table, how can I remove all of the $ signs?
QUESTION POSED ON: 18 JUL 2005
QUESTION ANSWERED BY: Rudy Limeback
Use the REPLACE function. It's perfect for this.
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
