Export Data in Fixed Width Format

[ICTGroup]

How can I export my results from PL/SQL dev into notepad as fixed width

eg.

select firstname, lastname, dob
from contact

result is
JO Bloggs 17041975

Would like it to be fixed width of 10:

JO........Bloggs....17041975..
(. indicates spaces)

Thanks

 

[ILoveOracle]

Hi,

Use the built-in RPAD Oracle function:

select RPAD(firstname, 10, ' ')
       || RPAD(lastname, 10, ' ')
       || RPAD(dob, 10, ' ')
from contact

For syntax, see http://www.csee.umbc.edu/help/oracle8/server.815/a67779/function.htm#1025045