---------- Post updated 02-12-15 at 12:18 AM ---------- Previous update was 02-11-15 at 11:40 PM ----------
Well as you said using HTML tags i tried but i thinking i am missing something
Code:
pending=`sqlplus -s pag_app/abcdef@prpx1-vip.unix.gsm1900.org:7779/prpx.unix.gsm1900.org <<EOF
set feedback off;
set heading off;
set trimspool on;
set pagesize 0;
SET LINESIZE 180;
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON
HEAD "<TITLE>Pending</TITLE>
<STYLE types='text/css'>
<!-- BODY {background: #FFFFC6}
</STYLE>"
BODY "TEXT='#FF00Ff'"
TABLE "WIDTH='90%' BORDER='5'"
SPOOL report.html
select msisdn,status_changed_time,rate_plan_id,status from subscriber where status = 'P' and status_changed_time < sysdate order b
y status_changed_time desc;
SPOOL OFF
EOF`
Output is as below
Code:
SP2-0734: unknown command beginning "HEAD "<TIT..." - rest of line ignored.
<br>
SP2-0734: unknown command beginning "<STYLE typ..." - rest of line ignored.
<br>
SP2-0734: unknown command beginning "<!-- BODY ..." - rest of line ignored.
<br>
SP2-0042: unknown command "</STYLE>"" - rest of line ignored.
<br>
SP2-0044: For a list of known commands enter HELP and to leave enter EXIT.
<br>
SP2-0734: unknown command beginning "BODY "TEXT..." - rest of line ignored.
<br>
SP2-0734: unknown command beginning "TABLE "WID..." - rest of line ignored.
<br>
<p>
<table border='1' width='90%' align='center' summary='Script output'> <tr> <td>
16268612580
</td>
<td>
11-FEB-15
</td>
<td align="right">
179
</td>
<td>
P
</td>
</tr>
<tr>
<td>
17327623109
</td>
<td>
11-FEB-15
</td>
<td align="right">
707
</td>
<td>
P
</td>
</tr>
---------- Post updated at 12:21 AM ---------- Previous update was at 12:18 AM ----------
I tried using HTML Report, i think i am missing something here
Code:
pending=`sqlplus -s pag_app/abcdef@prpx1-vip.unix.gsm1900.org:7779/prpx.unix.gsm1900.org <<EOF
set feedback off;
set heading off;
set trimspool on;
set pagesize 0;
SET LINESIZE 180;
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON
HEAD "<TITLE>Pending</TITLE>
<STYLE types='text/css'>
<!-- BODY {background: #FFFFC6}
</STYLE>"
BODY "TEXT='#FF00Ff'"
TABLE "WIDTH='90%' BORDER='5'"
SPOOL report.html
select msisdn,status_changed_time,rate_plan_id,status from subscriber where status = 'P' and status_changed_time < sysdate order b
y status_changed_time desc;
SPOOL OFF
EOF`
Output is below
Code:
SP2-0734: unknown command beginning "HEAD "<TIT..." - rest of line ignored.
<br>
SP2-0734: unknown command beginning "<STYLE typ..." - rest of line ignored.
<br>
SP2-0734: unknown command beginning "<!-- BODY ..." - rest of line ignored.
<br>
SP2-0042: unknown command "</STYLE>"" - rest of line ignored.
<br>
SP2-0044: For a list of known commands enter HELP and to leave enter EXIT.
<br>
SP2-0734: unknown command beginning "BODY "TEXT..." - rest of line ignored.
<br>
SP2-0734: unknown command beginning "TABLE "WID..." - rest of line ignored.
<br>
<p>
<table border='1' width='90%' align='center' summary='Script output'> <tr> <td>
16268612580
</td>
<td>
11-FEB-15
</td>
<td align="right">
179
</td>
<td>
P
</td>
</tr>
<tr>
<td>
17327623109
</td>
<td>
11-FEB-15
</td>
<td align="right">
707
</td>
<td>
P
</td>
</tr>
Please help if i am doing something wrong here
Moderator's Comments:
Please use QUOTE tags to display data that you are quoting from an earlier post; not to indicate your new comments in the current post.
Last edited by Don Cragun; 02-14-2015 at 12:52 AM..
Reason: Remove unneeded QUOTE tags.
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)
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)
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)
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)
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)
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)
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)
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)