|
|
adding blank spaces [message #316058 is a reply to message #316054] |
Wed, 23 April 2008 10:31   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
If i need to add blank spaces to a null column, how can i do that.. I have tried using rpad function.. but it does not work out for null values. I know we can use the nvl function for this.. but is there any alternate way to add, because in some cases i might need to add more 50 spaces..
|
|
|
Re: Pad blank spaces [message #316059 is a reply to message #316056] |
Wed, 23 April 2008 10:34   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
So, as per frank correction .. i have added this question at sql newbie. Please frank take some time there to answer this question.. I know there is way to do that using nvl function.. i am looking for alternate way, because i need to add more than 50 spaces to some null column values..
Appreciated Frank
|
|
|
|
|
fill blank spaces (merged 3) [message #316324 is a reply to message #316054] |
Thu, 24 April 2008 11:21   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
I need to hard code some column values as empty spaces in my program. That empty spaces might be 40 length long.. i know there is one to do it.. let's say if i need to print out a column with 3 spaces as empty ..
select ' ' as col from dual.
I am wondering .. is there any alternate way to do this .. because some fields are longer 40 length long to print out as empty...
|
|
|
fill blank spaces [message #316325 is a reply to message #316324] |
Thu, 24 April 2008 11:25   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
I need to hard code some column values as empty spaces in my program. That empty spaces might be 40 length long.. i know there is one to do it.. let's say if i need to print out a column with 3 spaces as empty ..
select ' ' as col from dual
I am wondering .. is there any alternate way to do this .. because some fields are longer 40 length long to print out as empty...
|
|
|
fill blank spaces [message #316326 is a reply to message #316324] |
Thu, 24 April 2008 11:27   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
I need to fill up some column values as empty spaces to print out. That empty spaces might be 40 length long.. i know there is one to do it.. let's say if i need to print out a column with 3 spaces as empty ..
select ' ' as col from dual
I am wondering .. is there any alternate way to do this .. because some fields are longer 40 length long to print out as empty...
[Updated on: Thu, 24 April 2008 11:28] Report message to a moderator
|
|
|
|
|
|
|
|
Re: pad/fill blank spaces (merged 4 topics) [message #316457 is a reply to message #316426] |
Fri, 25 April 2008 03:15  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
deepakkrjain wrote on Fri, 25 April 2008 09:04 | hi all,
this is very eassy to (insert or update) Blank space in null value Column. Used the Chr function. Blank Space Ascii Value is 32.
|
This has nothing to do with the original question.
|
|
|