Shell Programming and Scripting

First of all - why aren't you using the "code" tags? The Moderator has reminded you two times and is doing the work that you should be doing.
Please have a look at the video in Post #2 and use "code" tags whenever you post your code.

Now about your formatting - the source_name length could vary, but it can never exceed the size of the (I guess) VARCHAR2 datatype. So you could use the RPAD function to pad blank spaces to all the columns. Unfortunately, this will have to be hard-coded as per your table structure.

Another option could be to use an appropriate value for the "colsep" sqlplus variable. By default, it is a blank space (" "). Set it something like "|" and then remove the concatenation operators from your query.

Post your attempted code with "code" tags if you get stuck.

Sorry i am new to his forum , will take care of CODE tag next time..

i tried below query using 'colsep' and got the correct formatting in the commandline but when i receive the same out put in email body the last column got jumbled again.

Code:

SET COLSEP "|"
SELECT 'LOAD_DATE SOURCE_NAME COUNTS_MATCHING'
FROM dual
    UNION ALL
SELECT load_date,source_name,(CASE WHEN table_row_count = input_record_cnt THEN 'Yes' ELSE 'No' END)
FROM t1
 WHERE insert_date = TRUNC(SYSDATE);

email body output
-------------------

Code:

20170314|SRC_OMNI           |No
20170314|SRC_CUST_EMAIL      |Yes
20170314|SRC_CONTACT_HIST         |Yes
20170314|SRC_RESPONSE_HIST         |Yes
20170314|SRC_USERNAME_ACCT_  |Yes

Moderator's Comments:

Thanks for trying to use CODE tags; mistaken ICODE tags corrected.

Your command-line has a monospaced font - maybe "Terminal" or Raster Fonts. Each character uses up the same amount of horizontal space, so the character "i" and "w" will be of equal width. Due to such fixed-width font, you see the output formatted properly.

Your email client, most likely, has a variable width font like, say, "Arial" or "Times New Roman". The character "i" will use up less space than the character "w". Hence the formatting gets disrupted.

If you select the text in your email client and set the font to, say, "Courier New" or "Consolas" or "Terminal" etc. then you will be able to see it properly formatted in your email body. Check the top menu items of your email program to see how the font of selected text can be changed.

Code:

 If you select the text in your email client and set the font to, say, "Courier New" or "Consolas" or "Terminal" etc. then you will be able to see it properly formatted in your email body. Check the top menu items of your email program to see how the font of selected text can be changed.

.

Thanks for your valuable time.. i will look into this..i think it should work..

i have another query related to the same work flow..probably i will open a new thread for this..

thanks