Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

coalesce or NVL issue

677632May 27 2009 — edited May 27 2009
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2009
Added on May 27 2009
3 comments
648 views