Sponsored Content
Top Forums Shell Programming and Scripting Take Data From a table and send it through mail Post 302778021 by ginrkf on Saturday 9th of March 2013 08:07:59 AM
Old 03-09-2013
Thanks

How to store the output into a file .I am using oracle DB

I need to select 9 columns

---------- Post updated at 08:07 AM ---------- Previous update was at 06:22 AM ----------

Thanks

How to store the output into a file .I am using oracle DB

I need to select 9 columns
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Arrange Data in table and send by mail

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

How to send html file in a mail not as an attachment but it should display in the mail in table for

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

sending mail using Mailx with data from oracle table

Hi, i need to send emails to the mail ids i receive using the sql query . SELECT L.ALARM_DEF,L.CRITERIA,L.DISTANCE_METRE,L.EMAIL,L.LAC_ID,L.LAST_CHECK,L.RANGE, L.RESOURCE_MSISDN,LM.ADDRESS,LM.NAME FROM LANDMARK_ALARM_CONF l, LANDMARK lm WHERE L.LANDMARK_ID=LM.LANDMARK_ID AND... (0 Replies)
Discussion started by: aemunathan
0 Replies

4. Shell Programming and Scripting

Mailx command - send mail as table format

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

5. Shell Programming and Scripting

To send a mail when the data in a folder changes

Hi All, i have a folder "fold" which will mostly have a date( like 1/2/2013 -a single date alone .whenever the date changes i shoud get a mail. could someone help me with this. (4 Replies)
Discussion started by: mahesh300182
4 Replies

6. Shell Programming and Scripting

Represent the data in table format as in mail content

hi all, I want to Represent the data in table format in mail content sample data should be like this...but i m trying to send this table to mail using unix command...hw do i do????even i echoed the table contents ...doesnt work.... help me <table style="background-color:lightblue;">... (8 Replies)
Discussion started by: navsan
8 Replies

7. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

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

8. Shell Programming and Scripting

I want query output to send on mail using table tag and output should be in table

#! /bin/ksh #] && . ./.profile 2>/dev/null if test -f '.profile'; then . ./.profile; fi; #. .profile LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7" ( ... (21 Replies)
Discussion started by: ankit.mca.aaidu
21 Replies

9. Shell Programming and Scripting

Table to send mail

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

Send Data to MySQL Table Columns

I have two scripts, each script reads an individual data file and copies specific lines of data and sends to MySQL table. Only difference is, each script sends data to a separate column on the same DB. I want to use one script to populate DB table and have data look horizontal, with no overlapping.... (3 Replies)
Discussion started by: SysAdminRialto
3 Replies
BINMAIL(1)						      General Commands Manual							BINMAIL(1)

NAME
binmail - send or receive mail among users SYNOPSIS
/bin/mail [ + ] [ -i ] [ person ] ... /bin/mail [ + ] [ -i ] -f file DESCRIPTION
Note: This is the old version 7 UNIX system mail program. The default mail command is described in Mail(1), and its binary is in the directory /usr/ucb. mail with no argument prints a user's mail, message-by-message, in last-in, first-out order; the optional argument + displays the mail mes- sages in first-in, first-out order. For each message, it reads a line from the standard input to direct disposition of the message. newline Go on to next message. d Delete message and go on to the next. p Print message again. - Go back to previous message. s [ file ] ... Save the message in the named files (`mbox' default). w [ file ] ... Save the message, without a header, in the named files (`mbox' default). m [ person ] ... Mail the message to the named persons (yourself is default). EOT (control-D) Put unexamined mail back in the mailbox and stop. q Same as EOT. !command Escape to the Shell to do command. * Print a command summary. An interrupt normally terminates the mail command; the mail file is unchanged. The optional argument -i tells mail to continue after interrupts. When persons are named, mail takes the standard input up to an end-of-file (or a line with just `.') and adds it to each person's `mail' file. The message is preceded by the sender's name and a postmark. Lines that look like postmarks are prepended with `>'. A person is usually a user name recognized by login(1). To denote a recipient on a remote system, prefix person by the system name and exclamation mark (see uucp(1C)). The -f option causes the named file, for example, `mbox', to be printed as if it were the mail file. When a user logs in he is informed of the presence of mail. FILES
/etc/passwd to identify sender and locate persons /usr/spool/mail/* incoming mail for user * mbox saved mail /tmp/ma* temp file /usr/spool/mail/*.lock lock for mail directory dead.letter unmailable text SEE ALSO
Mail(1), write(1), uucp(1C), uux(1C), xsend(1), sendmail(8) BUGS
Race conditions sometimes result in a failure to remove a lock file. Normally anybody can read your mail, unless it is sent by xsend(1). An installation can overcome this by making mail a set-user-id command that owns the mail directory. 7th Edition April 29, 1985 BINMAIL(1)
All times are GMT -4. The time now is 08:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy