srpendyala
asked on
SQL remove middle space
I have a situation where I get the following output
select date from dual;
OUTPUT
september2004,
august2004,
september 2004,-----middle space
august 2004-----------middle space
I need the output without middle space
Required output
september2004,
august2004,
september2004,--- without middle space
august2004-------without middle space
Thanks
Srini
select date from dual;
OUTPUT
september2004,
august2004,
september 2004,-----middle space
august 2004-----------middle space
I need the output without middle space
Required output
september2004,
august2004,
september2004,--- without middle space
august2004-------without middle space
Thanks
Srini
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select to_char(date,'fmmonthyyyy'
in format mask 'fm' excludes spaces.