${SQLPLUS} -S ${CONNECT_STR} <<EOF >>${LOG_FILE}
select sysdate from dual;
exit
EOF
At the moment only the query result will be written to the log file. Is it possible that the sql statement will also be shown in the log file? One of my ideas is to prompt the statement additionally. Another way would be that the statement is in a sql script and set echo on. Or is there another simple way?