Fill with blanks(spaces) a VARCHAR2 type
Thanks in advance,
I have a VARCHAR2 type rtesta's var of length x(100 char)
how i can fill(write) it without create a other varchar2 var that it'll be only filled with blanks(spaces). e.g
rtesta := ' PC'||fil1||'xxx||fill2....
where fil1 = say 10 spaces.. fill2 = 63 spaces and so on
I would like something as
rtesta := ' PC'|| RPAD(null,10)||'xxx||RPAD(null,63) ...
but.... Oracle treats an empty string as null. And nulls are always a bit special within Oracle. Particularly, rpad('', n) and lpad('', n) returns null.
Exists a built in for my problem?
Thanks