Just to clarify (Insert <CR><LF>):

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

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
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


-----Original Message-----
From: Armstrong Richard
[mailto:oracledba-ezmlmshield-x15441091.[Email address protected]
Sent: Wednesday, August 31, 2005 4:43 PM
To: LazyDBA Discussion
Subject: RE: SQL Format Help

There is really nothing inherent in pure naked SQL to do formatting on
result sets. You have to rely upon whatever formatting features are
provided in the tool you are using to execute the SQL. It's a
tool-dependent thing.

In your situation, you could use some carriage return characters similar
to how you are doing it below with the string concatenation. Just
concatenate some return characters in the right places.

-Richard



-----Original Message-----
From: Derrick Pitts
[mailto:oracledba-ezmlmshield-x12295303.[Email address protected]
Sent: Wednesday, August 31, 2005 8:51 AM
To: LazyDBA Discussion
Subject: SQL Format Help

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



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


Oracle LazyDBA home page