coalesce or NVL issue
677632May 27 2009 — edited May 27 2009Hi,
I have given the below query at SQL prompt
I need to check for emp_name. If emp_name has null values then I need to replace NULL value with 50 spaces.
select coalesce(emp_name, ' ') from employees;
Please let me know, Is there any way to give number of spaces to replace rather than mentioning space 50 times in query. Thanks in advance.