I need to strip leading spaces from a column in Oracle. I've Googled but haven't found any answers except to write my own function which I'd like to avoid.
What's the easiest way to accomplish this?
You can user LTRIM Oracle function:
SQL> select ltrim(' hello world') from dual;
For ending spaces you can use RTRIM. And for more options check out TRIM.