Shell Programming and Scripting

Execute the sqlplus command and store it's output into variable X.
The sqlplus command is started with the -s option that means silent mode.
The user and passord for connection to the database is specified on the command line user/pwwd@domain

The syntax <<eof specifies that the input for the sqlplus command is included in the script starting next line and ending with the line eof

Jean-Pierre.

Aigles is absolutely right what he has explained i would like to add few lines.

Code:

sqlplus -s user/pwwd@domain

this line of code will invoke sqlplus and will login to database with "user" and "passwd" in "domain".
now you are in sqlplus and run procedure,functions etc as you can do it in
sqlplus session.

<<eof
.......
.........
......
eof
this is known as here document.

if we do any print as in unix is echo and sqlplus is dbms_output.put_line will come to shell variable X.

mailx -s "Please check" test@yahoo.com

After giving this command on unix box whether i have to put any control key
mail is not sending