02-04-2010
Hi All,
i need a script to select record from oracle and send mail
there are multiple records in the table i need to read row by row and send mail
pls help
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am coding shell script.
I need to connect to different databases like DB2, Oracle and Sybase.
I would then need to query tables where it has all the groups, users for that database.
I would also need who has what kind of permissions.
EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies
2. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
3. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
4. Shell Programming and Scripting
hi Guys,
i have a problem with oracle query in my unix script..
I'm getting the following error while executing..
./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
7. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
8. Shell Programming and Scripting
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies
9. Shell Programming and Scripting
Hi,
Im new to DB2.
I need to connect to DB2 from shell script and return the query output back to shell script variable.
this is my code
#!/bin/ksh
db_name=db
db_user=usr
db_pwd=pwd
db2 <<EOSQL
connect to $db_name user $db_user using "$db_pwd"
select count(1) from table
quit
EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies
10. Shell Programming and Scripting
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 Replies
mhmail(1) General Commands Manual mhmail(1)
NAME
mhmail - send or read mail (only available within the message handling system, mh)
SYNOPSIS
mhmail [addrs...] [options]
OPTIONS
Specifies the text of the message. If it is specified, then the standard input is not read. Specifies addresses to be placed in the cc:
field of the message. Specifies the content of the From: header of the draft. The address given is placed in the From: field of the mes-
sage. The Sender: field is filled in correctly by post. Prints a list of the valid options for this command. Specifies the mail system
over which mail is sent. The only value allowed is smtp, which is the standard mail system. Additional values are supported only for use
with other mail systems. Provides the text of the Subject: field of the message.
DESCRIPTION
The mhmail program is intended as a replacement for the standard mail programs, bellmail and ucbmail. See binmail(1) and mail(1) for more
details of these mail programs. When invoked without arguments, it simply invokes inc to incorporate new messages from the user's maildrop.
When one or more users is specified, a message is read from the standard input and spooled to a temporary file. The mhmail program then
invokes post with the name of the temporary file as its argument to deliver the message to the specified user.
Normally, people will use comp and send to send messages.
RESTRICTIONS
Messages with a null body part will not be sent by mhmail. You must include some body text in all messages to be sent by mhmail.
For this version, the -mts option only supports the value smtp. Additional values are supported for use only with other mail systems.
FILES
Program to incorporate a maildrop into a folder. Program to deliver a message. Temporary copy of message.
SEE ALSO
inc(1), post(8)
mhmail(1)