Fixed-length fields you can get in SQL*Plus by setting field formats and field separator or with SQL (PL/SQL) by using LPAD and RPAD functions and concatenating fields to one string.
Sending the email is another issue, depends on way you'd like to use and on your OS.




Reply With Quote