You can use "trim()" function to do that. Look at Oracle SQL Manual to find out how to use trim() function. If you want to correct data in a table to get rid of leading spaces, use Update with trim function. Did a google search with "oracle trim function" and got lots of hits.
www.google.com