Shell Programming and Scripting

cnt=`sqlplus -s /nolog << EOFSQL  
              connect $USER/$PASS@$DB
		SET pagesize 0 feedback off verify off heading off echo off
			select COUNT(1) from dual;
		exit;
		EOFSQL`

cnt=`sqlplus -s ${USER}/${PASS}@${DB} << EOF
SET pagesize 0 feedback off verify off heading off echo off
select COUNT(1) from dual;
exit;
EOF`

SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

cnt=`sqlplus -s ${USER}/"${PASS}"@${DB} << EOF