Gurus,

I have a prodecure that runs and sends out an email with counts on the
number of records entered. I need some help figuring out how to get the
format more clear.

send_email('[Email address protected] process has
completed' || 'oradba.DATA_TAPE_APPLICANT: ' || l_app_count ||
'oradba.DATA_TAPE_TXN_CODES: ' || l_app_count || 'oradba.DATA_TAPE_ASSET: '
|| l_app_count || 'oradba.DATA_TAPE_LOANINFO: ');

This is how it currently looks in the email.

The process has completedoradba.DATA_TAPE_APPLICANT:
19659oradba.DATA_TAPE_TXN_CODES: 19659oradba.DATA_TAPE_ASSET:
19659oradba.DATA_TAPE_LOANINFO:19659

How do I format this to put each sentence on a separate line, like this for
instance?

The process has completed
oradba.DATA_TAPE_APPLICANT : 19659
oradba.DATA_TAPE_TXN_CODES : 19659
oradba.DATA_TAPE_ASSET : 19659
oradba.DATA_TAPE_LOANINFO : 19659


Oracle LazyDBA home page