Mdthbs

Canteen Cutlery Issue

Query to get counts of values per column

Could Boris Johnson face criminal charges for illegally proroguing Parliament?

Does Hogwarts have its own anthem?

Chain on singlespeed tight, pedals won't turn backwards very freely - is this an issue?

Generating numbers with cubes

Mac no longer boots

What are one's options when facing religious discrimination at the airport?

Why does the Pilatus PC-24 have such a large "Wing Support"?

Citing CPLEX 12.9

Is morphing a creature effectively a cost?

Does the 'java' command compile Java programs?

Sending mail to the Professor for PhD, after seeing his tweet

Is there a way to double indent equations

What makes a character irredeemable?

Check if number is in list of numbers

Bwv 639 Bach/Busoni note length and symbols

Are there types of animals that can't make the trip to space? (physiologically)

Security risks of disabling "Find my iPhone"?

Anonymous reviewer disclosed his identity. Should I thank him by name?

Why is music is taught by reading sheet music?

Parent asking for money after I moved out

Why is there such a singular place for bird watching?

As an interviewer, how to conduct interviews with candidates you already know will be rejected?

How to draw HTML table having contain result of SQL query and send to mail in Shell script

How do I send HTML email using linux 'mail' command?Why does my cronjob not execute my shell-script?How to write down SQL query to get the data count of a table?How to configure 'at' and 'sendmail' to mail output with Content-Type: text/htmlShell script : Redirect sql query output to a file

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{
margin-bottom:0;
}

0

1

I want to draw HTML table contain record of SQL query and send to mail in shell script.
Here is the shell script:-

#!/usr/bin/ksh

out=$(for id in 1 2 3 4

      do

      sqlplus -s <user>/<password>@<db> <<EOF

      spool out.txt;

      select * from <table> where id=${id};

      spool off;

      exit;

      EOF

      done)



 echo ${out} > out.txt

(uuencode out.txt out.txt)| cat out.txt| mailx -s "Counts" abc@xyz.com

And I am getting output of the query in different format not HTML table format.

The table format should be like this (in the table)

ID            Results

        Before      After

1          12         15

2          27         30 

3          45         52

Could you please help me to draw HTML table of this record.

shell-script html sql

share|improve this question

edited 5 mins ago

Md Wasi

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge

New contributor

Md Wasi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment
 | 

0

1

I want to draw HTML table contain record of SQL query and send to mail in shell script.
Here is the shell script:-

#!/usr/bin/ksh

out=$(for id in 1 2 3 4

      do

      sqlplus -s <user>/<password>@<db> <<EOF

      spool out.txt;

      select * from <table> where id=${id};

      spool off;

      exit;

      EOF

      done)



 echo ${out} > out.txt

(uuencode out.txt out.txt)| cat out.txt| mailx -s "Counts" abc@xyz.com

And I am getting output of the query in different format not HTML table format.

The table format should be like this (in the table)

ID            Results

        Before      After

1          12         15

2          27         30 

3          45         52

Could you please help me to draw HTML table of this record.

shell-script html sql

share|improve this question

edited 5 mins ago

Md Wasi

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge

New contributor

Md Wasi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment
 | 

I want to draw HTML table contain record of SQL query and send to mail in shell script.
Here is the shell script:-

#!/usr/bin/ksh

out=$(for id in 1 2 3 4

      do

      sqlplus -s <user>/<password>@<db> <<EOF

      spool out.txt;

      select * from <table> where id=${id};

      spool off;

      exit;

      EOF

      done)



 echo ${out} > out.txt

(uuencode out.txt out.txt)| cat out.txt| mailx -s "Counts" abc@xyz.com

And I am getting output of the query in different format not HTML table format.

The table format should be like this (in the table)

ID            Results

        Before      After

1          12         15

2          27         30 

3          45         52

Could you please help me to draw HTML table of this record.

shell-script html sql

share|improve this question

edited 5 mins ago

Md Wasi

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge

New contributor

Md Wasi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

#!/usr/bin/ksh

out=$(for id in 1 2 3 4

      do

      sqlplus -s <user>/<password>@<db> <<EOF

      spool out.txt;

      select * from <table> where id=${id};

      spool off;

      exit;

      EOF

      done)



 echo ${out} > out.txt

(uuencode out.txt out.txt)| cat out.txt| mailx -s "Counts" abc@xyz.com

ID            Results

        Before      After

1          12         15

2          27         30 

3          45         52

share|improve this question

edited 5 mins ago

Md Wasi

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge

New contributor

Md Wasi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 5 mins ago

Md Wasi

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge

New contributor

Md Wasi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge

New contributor

Md Wasi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 22 mins ago

Md WasiMd Wasi

10111 bronze badge