Search Results

You should login in single user mode to increase the space for /usr or /tmp or /var mount points.

Looking at your output, it clearly says the usage of sqlplus option is not proper.

Try the following

sqlplus << EOF > o.txt
username/password
set linesize 1000
set head off

<your query...

You'll have to write this for every column of the table.

Just update the table columns like :

update <table name>
set column1 = REPLACE(column1, ' '),
column2 = REPLACE(column2, ' '),
.
....

In sql you can use the inbuilt function REPLACE(orig_string, string_to_be_replaced, new_String)

For e.g.
SELECT ('abcd efg hij',' ',null) from dual;
OR
SELECT ('abcd efg hij',' ') from dual;...