Sponsored Content
Top Forums Shell Programming and Scripting Unable to retrieve data from shell when connected to Oracle Post 302708661 by Kiransagar on Tuesday 2nd of October 2012 01:41:55 AM
Old 10-02-2012
code for output of a spoolfile through mail

Hi

I want to send the output of a spool file through mail.FYI..the spool file consists of output of a select comand with only 3 columns.The mail should be sent to a list of people .I didn't have a good knowledge on Shell what I can see is that the list of people where added to a variable list and called the mailx command.

Can some one please send me the code how to do this by taking above two consideration

Thanks in Advance
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Retrieve Oracle export to tape

Hi! We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1 The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive... (1 Reply)
Discussion started by: sdharmap
1 Replies

2. Shell Programming and Scripting

Shell Script for Data loading in Oracle

Hi All I am new to unix. I need a shell script to load a datafile in to oracle. I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table. Control file : PAY0001.ctl Datafile : mon_grs_det.dat log file :... (3 Replies)
Discussion started by: raghuraja_r
3 Replies

3. Shell Programming and Scripting

Need shell script to extract data from oracle database

shell script (4 Replies)
Discussion started by: frns5
4 Replies

4. Shell Programming and Scripting

How to fetch data from oracle in unix shell script

Hi, How to fetch data from oracle database in unix shell scripting. list=`sqlplus -s ds_user/dsuser@EMI <<EOF set feedback off set serveroutput on set heading off set pagesize 0 set tab off select IP_ID from table / exit EOF` The output is not what i expected.I need output in... (4 Replies)
Discussion started by: Anusha_Reddy
4 Replies

5. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

6. Shell Programming and Scripting

why do we need UNIX shell script to load data into Oracle database

Hello everyone, I am new to shell scripting/ loading data into a database. I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies

7. Shell Programming and Scripting

Loading data in oracle using shell scripts

Hi , I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory. Any help will be appreciated. ... (4 Replies)
Discussion started by: guddu_12
4 Replies

8. SuSE

HELP for Newbie: Unable to run GUI installer (Ubuntu client connected to SLES server)

Hello All, I'm using my Ubuntu 10.04 client connected via SSH to a SuSE Linux server (SuSE Linux Enterprise Server 11 (x86_64) version 11 patchlevel=1). I'm trying to run an install of WebSphere Portal but can't seem to be able to run the GUI installer. Running xclock as root returns this... (7 Replies)
Discussion started by: kartrait
7 Replies

9. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

10. 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
vacation(1)						      General Commands Manual						       vacation(1)

NAME
vacation - Informs senders of mail that recipient is absent SYNOPSIS
vacation -I The vacation command returns a message to the sender of a mail message, saying that the recipient is on vacation or otherwise absent. OPTIONS
Initializes the $HOME/.vacation.pag and $HOME/.vacation.dir files. Execute this option before you modify your $HOME/.forward file. DESCRIPTION
The vacation command accepts standard input and attempts to send a vacation message to the user specified in that input, which should be a mail message. The vacation command is usually invoked in your $HOME/.forward file, which is used to forward your mail to another username. When you want vacation messages to be sent to users who send you mail, enter the following in your $HOME/.forward file: user, "|vacation user" Replace user by your username. This allows mail sent to you to be both received by you and piped to the vacation command; vacation reads the mail message, determines the sender, and sends a reply. The sender receives a vacation message, and the original mail is waiting in your mailbox when you return. When vacation is invoked without the -I option, as in the file, it reads the first line from the standard input for a From line to deter- mine the sender. If this is not present, an error message is produced. (All properly formatted incoming mail should include a From line.) No vacation message is sent if the From header line indicates that the message is from Postmaster; from MAILER-DAEMON; if the initial From line includes the string -REQUEST@; or if a Precedence: bulk or Precedence: junk line is included in the header. You must initialize vacation for your username by issuing the command vacation -I before you can use the vacation command. The vacation command expects a $HOME/.vacation.msg file containing a message to be sent back to each sender. The file should be an entire message, including any desired headers, such as From or Subject. This message will be sent only once a week to each unique message sender. (If this file does not exist, vacation uses /usr/share/lib/vacation.def, a system-wide default vacation message, if it exists.) The names of people who have sent you messages are kept in the files $HOME/.vacation.pag and $HOME/.vacation.dir. These files are created when you initialize vacation for your username with vacation -I. EXAMPLES
If your username is myra and you want to send a message once a week to each person who has sent you mail, initialize vacation by entering: vacation -I Next, add the following line to your $HOME/.forward file (create this file if it does not exist): myra, "|vacation myra" If you want to send a vacation message other than the system default message in /usr/share/lib/vacation.def, create the file in your home directory and enter the message in it. For example: From: myra@k.table (Myra Louise Minter) Subject: I am on vacation. Delivered-By-the-Graces-Of: the Vacation program I am on vacation until October 1. If you have something urgent, please telephone Lucy or Sue. -- Myra FILES
System-wide default vacation message. Contains address to which mail is forwarded. Contains the names of people who have sent you mail while the vacation command was being used. Contains the names of people who have sent you mail while the vacation command was being used. Contains your personal vacation message. SEE ALSO
Commands: mail(1), mailx(1), sendmail(8) vacation(1)
All times are GMT -4. The time now is 01:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy