massmaharaj Posted March 21, 2012 Report Share Posted March 21, 2012 I have a column comment_txt which is varchar2 - 1000 size in that column, i will get the data for some rows with double quotes , and for other rows it will get the text my requiremetn is if the column which has data with double quotes i need to change that as single quotes suppose if the column She should not be calling me "Dear". expected should be She should not be calling me 'Dear'. those which doesnot have quotes , it should come like as is please help Thanks Quote Link to comment Share on other sites More sharing options...
Bhayya Posted March 21, 2012 Report Share Posted March 21, 2012 replace function vaadu Quote Link to comment Share on other sites More sharing options...
Bhayya Posted March 21, 2012 Report Share Posted March 21, 2012 replace('222tech', '2', '3'); Quote Link to comment Share on other sites More sharing options...
massmaharaj Posted March 21, 2012 Author Report Share Posted March 21, 2012 Thank you Subbarav i got it used the replace function Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.