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


Oracle LazyDBA home page