02-11-2015
If you show us the SELECT statement you are now using and we can probably adjust it.
Is there a reason for having it in boxes? It will make it more difficult to use the data later on. For a report to be published, it's usual to have a comma separated file that you can read into a spreadsheet. You can graph it then, which can be much better for understanding the information you wish to convey rather that just the raw data.
Robin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Everybody,
can you tell me how express about this; we have text data file as :
parameter1 Parameter2
AA 55
BB 77
. .
. .
. .
We want to draw table for this data as attached then send as body of Email (4 Replies)
Discussion started by: xjklop2009
4 Replies
2. UNIX for Dummies Questions & Answers
Hi
The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment .
cat Employee.sql
SET VERIFY OFF
SET PAGESIZE 200
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD... (0 Replies)
Discussion started by: mani_isha
0 Replies
3. Shell Programming and Scripting
I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong.
Intended Output in mail body:
Col1 Col2 Col3
------ ... (2 Replies)
Discussion started by: qwertyu
2 Replies
4. Shell Programming and Scripting
Hi can anyone help me in writing a code for taking data from a table and need to send that data through mail using mail -x command.. (3 Replies)
Discussion started by: ginrkf
3 Replies
5. Shell Programming and Scripting
Hello,
Currently i have a script which will disply the results in plain text format.
I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html and send that content as email.
Please help me how i can do that.
I am using... (10 Replies)
Discussion started by: joy lobo
10 Replies
6. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
7. Solaris
Hi how to send below prstat script output into table format and send through email?
prstat|awk '{ if ($9 >= 5) print $0 }' (17 Replies)
Discussion started by: tharmendran
17 Replies
8. Solaris
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 Replies)
Discussion started by: tharmendran
2 Replies
9. Shell Programming and Scripting
I have two details to send in html email, two details present in variables, Processname & date which I need to send html email in table. Column1 is Processname: Process1 & column 2 is date:16/6/16 4:55 AM
I have below basic html code, how to create table in html to send mail
echo "<html>" >>... (1 Reply)
Discussion started by: rozee
1 Replies
10. Shell Programming and Scripting
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
dfc(1) USER COMMANDS dfc(1)
NAME
dfc - display file system space usage using graph and colors
SYNOPSIS
dfc [OPTION(S)] [-c WHEN] [-u UNIT] [-t FILESYSTEM]
DESCRIPTION
dfc(1) is a tool similar to df(1) except that it is able to show a graph along with the data and is able to use color (color mode is
"color-auto" by default but you can change this with "-c" option).
The available size correspond to the space available to a user point of view and not from root's perspective (ie: use f_bavail instead of
f_bfree). In the same idea, used space is computed simply by substracting the available space from the total size.
Without any argument, size is displayed in human readable format. Be aware that when using human-readable format, there might be some
rounding when computing the size. If you want maximum precision, use the "-u" option and choose the unit.
dfc(1) also has a built in feature that makes the output auto adjust based on terminal width. If you want to override this behavior, use
the "-f" option.
OPTIONS
-a Show information about all file systems found in the mtab file.
-b Do not show the graph bar.
-c [WHEN]
Choose color mode where WHEN is one of the following sub-option:
"always": Color will always be used, no matter what stdout is.
"auto": This is default when "-c" is not activated. Color is used only if "stdout" is a terminal. For instance, color will be
disabled with this option if you pipe the output of dfc(1) into another command.
"never": Color will never be used.
-f Override auto-adjust behavior by forcing information to be displayed. You probably do not want to activate this option but choice
is yours. This option may be useful if you pipe the output of dfc(1) though.
-h Show a short help text.
-i Show information about inodes.
-m Use SI units (metric) (ie: size is computed using powers of 10 instead of powers of 2).
-n Do not print header.
-o Show mount options.
-s Sum the total usage.
-t [FILESYSTEM]
Allows you to perform filtering on file system type. FILESYSTEM could take any known file system value. For instance, "ext4", "ufs",
"tmpfs", "reiserfs", etc.
Multiple selection on file system is also possible. In this case, FILESYSTEM needs to be comma separated (without spaces). For
instance, if you want to filter "ext4" and "tmpfs", you would use the following:
dfc -t ext4,tmpfs
You can also use negative matching to filter the output. To do so, you just need to prepend a "-" to FILESYSTEM. In the following
example, dfc(1) will display all file system type except those mentionned:
dfc -t -rootfs,tmpfs
-T Show filesystem type.
-u [UNIT]
Show size using unit specified. UNIT can take one of the following value:
"h": Human readable (default when not using "-u" option).
"b": Show bytes.
"k": Show size using Kio.
"m": Show size using Mio.
"g": Show size using Gio.
"t": Show size using Tio.
"p": Show size using Pio.
"e": Show size using Eio.
"z": Show size using Zio.
"y": Show size using Yio.
NOTE: When using "-u" option along with "-m" option, those suboptions are replaced by their SI counterparts.
-v Print dfc(1) version and exit.
-w Use a wider bar.
-W Wide path name (avoid truncation of file name). May require a larger display.
BUGS
If you find one, please contact the author and explain what you encounter.
AUTHORS
Robin Hahling (robin.hahling (at) gw-computing.net)
COPYRIGHT
Copyright (C) 2012 Robin Hahling
LICENSE
3 Clauses BSD
SEE ALSO
df(1), du(1)
version 2.5.0 April 3, 2012 dfc(1)