Hello All,
I loaded text into Oracle table and stored as clob. However, there are many space between the words. Would you please show me how to remove the space between the words like da ta and dome stic?
table T1 contains filetext. One of row in the table looks like this:
filetext = '<P>The dollar value of the entire shipment. This was defined as the net selling
value, f.o.b. plant, exclusive of freight charges and excise taxes. The value da
ta are displayed in millions of dollars.</P>
<P>The total value of shipments, as measured by the CFS, and the U.S. gross dome
stic product (GDP) while similar in size provide different measures of economic
activity in the United States and are not directly comparable'
I am very appreciated all the help from you
Jenny