Doubt??

Shell Programming and Scripting
1

I jus want to know the meaning of the below command line(exclamation following that re-direction)

sqlplus -s `cat /home/sample.txt` <<!

Thanks!!

2

In this case all lines in the shell script up to the first line starting with the exclamation mark will be read by sqlplus. The exclamation mark itself is just a string rather than any particular syntax. It is conventional to use "EOF" or "EOSQL" but exclamation mark will do. Beware that any $ signs in SQL syntax will have to be escaped as \$ .

sqlplus -s username/password <<EOF

SQL commands go here.

EOF

More shell commands