help needed please.
I am writing directly to email in pl/sql via UTL_SMTP. The problem is that rows are not aligned or left adjusted with the header record using LPAD/RPAD. This is my code just showing how the header and are padded
v_heading := rpad('Surname',20,'.')||rpad('Forename',15)|||chr(13);
loop
.
v\_deatail := rpad(v\_surname,20,'.')||rpad(v\_forename,15,'.')||chr(13)||chr(13)||
.
end loop
This is the output I get
But I want to align the header and the detail like this
Surname Forename
Bao Keren
I am not sure if this is to do with fonts on the email but any help will be appreciated.
Thanks