white [message #36587] |
Wed, 05 December 2001 10:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adelia
Messages: 45 Registered: April 2001
|
Member |
|
|
How can I concatenate variables white spaces with a string
Eg : select rpad(name,' ',20-LENGTH(Name))
from names;
----------------------------------------------------------------------
|
|
|
Re: white [message #36590 is a reply to message #36587] |
Wed, 05 December 2001 10:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
If you just want the column right-padded with spaces to a width of 20:
select rpad(name, 20) from names
----------------------------------------------------------------------
|
|
|