replace multiple spaces with single space.

Answer Posted / pushpendra

replacechr function can use.

replacechr(0,Column_Name,' ','')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blocking transformation?

712


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

548


What is a code page?

707


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493


I have a flat file, want to reverse the contents of the flat file

686






what is the size of u r source(like file or table)?

1812


What is pmcmd command?

668


What is workflow? What are the components of the workflow manager?

631


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3502


What is the session task and command task?

591


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6748


What is a passive transformation?

636


What does command task mean?

606


Different sorts of metadata that stores in the storage facility?

554


server hot-ws270 is connect to Repository B. What does it mean?

1850