Re: Adding Blank Spaces in Stored Procedures

Nilima Desai wrote:

> Hello,
>
> I need to add spaces between fields when I am appending to the text
> file,
> or, if the field is empty, I want to assign blank spaces based on the
> length of the field. I have tried an IF statement that checks for each
>
> field, and if it is null it inserts blank spaces using open and
> close quotes.
>

Oracle doesn't store trailing spaces in VARCHAR2 columns. Use CHAR instead.

Kind regards,

Kees Verruijt Received on Mon Jul 28 1997 - 00:00:00 CDT