Shell script to access sqlplus

Question

can anyone help me in wiring a shell script to acess sqlplus . In sqlplus i need to run a sql script and mail the result back to a mail id.

example

ls dir ----> has  abc.sql

i go to sqlplus and run query by ==> **sqlplus username/password@instance @abc**

I want to mail the result to [email protected]

Dennis Williamson · Accepted Answer · 2010-12-23 01:45:10Z

3

You should be able to do:

sqlplus username/password@instance @abc | mail -s "Email Subject" [email protected]

answered Dec 23, 2010 at 1:45

Dennis Williamson

364k95 gold badges386 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

misguided Over a year ago

Thanks for the reply. But when I try the above line , the system doesn't do anything. Then i had to cancel ^Z[1] + Stopped (SIGTSTP) sqlplus username/password@instance @abc | mail -s "Email Subject" [email protected]

Dennis Williamson Over a year ago

@misguided: If you do the sqlplus command by itself, do you get output to the screen? If you do echo "hello" | mail -s "test message" [email protected], do you get that email?

Raghuram · Accepted Answer · 2010-12-23 01:48:14Z

0

You shuld redirect the output of sqlplus to a file And then use mailx to send that to specified email id.

answered Dec 23, 2010 at 1:48

Raghuram

3,9672 gold badges21 silver badges25 bronze badges

1 Comment

glenn jackman Over a year ago

don't need the file, just pipe directly to mailx

Collectives™ on Stack Overflow

Shell script to access sqlplus

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related