Sponsored Content
Top Forums Shell Programming and Scripting Take Data From a table and send it through mail Post 302778059 by Yoda on Saturday 9th of March 2013 11:16:34 AM
Old 03-09-2013
SQL*Plus command SPOOL can be used to store query result in file.

Syntax:
Code:
SPOOL filename
--your query here
SPOOL OFF

Note: Search the internet and you will find many examples of spooling along with how to format query results.
 

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
FETCHYAHOO(1)						      General Commands Manual						     FETCHYAHOO(1)

bg.

NAME
fetchyahoo - retrieve mail from Yahoo!'s webmail service SYNOPSIS
fetchyahoo [options] DESCRIPTION
FetchYahoo is a Perl script that downloads mail from a Yahoo! account to a local mail spool. It is meant to replace fetchmail for people using Yahoo! mail since Yahoo!'s POP service no longer free. It downloads messages to a local mail spool, including all parts and attach- ments. It then deletes messages unless requested not to. It can also optionally forward messages to a specified e-mail address and repeat with a given interval. OPTIONS
This program follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. For additional information, see the HTML documentation. --help Show summary of options. --version Show version of program. --quiet, --noquiet Suppress (or do not suppress) non-error messages. --noerrors, --errors Suppress (or do not suppress) error messages. --configfile=CONFIG-FILE Use CONFIG-FILE as the configuration file. --username=USERNAME Use USERNAME as the Yahoo! login. --password=PASSWORD Use PASSWORD as your Yahoo! password. --spoolfile=SPOOL Specify SPOOL as the file to spool messages to; if --pipe is also specified, SPOOL is a program that accepts messages from standard input (such as procmail). --https --nohttps Use insecure plaintext or secure HTTPS to login (default is to use HTTPS). --append Append messages to the SPOOL (the default behavior). --pipe Pipe messages to the program SPOOL, instead of appending to SPOOL. --overwrite Overwrite SPOOL, instead of appending to it. --folder=FOLDER Specify the folder on Yahoo! to download messages from. (Default is Inbox.) --newonly Only download new messages. (The default is to download all messages.) --allmsgs Download all messages. --nodelete, --delete Do not (or do) delete messages after they are downloaded. --nodownload, --download Do not download messages; however, they will be deleted unless --nodelete is also specified. (--download is the default.) --listmessages, --nolistmessages List messages in mail folder. (--nolistmessages is the default.) --onlylistmessages Only list messages in mail folder. This combines --listmessages, --nodownload and --nodelete --emptybulk Empty Bulk folder before downloading messages. --emptytrashbefore Empty trash before downloading messages. --emptytrashafter Empty trash after downloading messages. --noempty Do not empty trash or bulk. (Default) --leaveunread Leave the messages marked as unread on the server. --markread Mark the messages downloaded as read. (Default) --repeatinterval=N Check for mail every N minutes. --statusonly, --nostatusonly Just get the number of messages. (--nostatusonly is the default.) --getexternal, --nogetexternal Retrieve messages from external mailboxes also. (--nogetexternal is the default.) --externalmailboxes=boxes,list retrieve messages from only this comma-separated list of external mailboxes --maxmessages=N Maximum number of messages to download (default is 100). Setting this to over 100 may cause problems. --warninglevel=N Warn if more than N% of storage quota is used. Never warn if N=0 (default is 0). --nofromline, --includefromline Omit (or include) the leading "From " in messages appended or piped. (--includefromline is the default.) --logout, --nologout Log out (or do not log out) of Yahoo! on exit. (--nologout is the default.) --proxyhost=s Hostname to use for proxy (default is off). --proxyport=N Port to use for proxy (default is 80). --proxyuser=s Username to use for proxy authentication (default is no authentication) --proxypass=s Password to use for proxy authentication (default is no authentication) --imaphost=s Hostname to use for IMAP (default is off). --imapport=N Port to use for IMAP (default is 143). --imapuser=s Username to use for IMAP authentication (no default) --imappass=s Password to use for IMAP authentication (no default) --imapmailbox=s IMAP mailbox to use (default is INBOX) --repeatinterval=N Check for mail every N minutes (daemon mode). --md5hex Print the MD5 hex hash value of a password entered interactively FILES /etc/fetchyahoorc $HOME/.fetchyahoorc Configuration files for FetchYahoo. An example configuration file is located in /usr/share/doc/fetchyahoo/examples/ SEE ALSO
procmail(1) /usr/share/doc/fetchyahoo/index.html AUTHOR
FetchYahoo was written by Ravi Ramkissoon <ravi_ramkissoon@yahoo.com>. This manual page was written by Chris Lawrence <lawrencc@debian.org>, for the Debian GNU/Linux system (but may be used by others). September 20, 2002 FETCHYAHOO(1)
All times are GMT -4. The time now is 06:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy