Shell Programming and Scripting

foll. is my code snippet.

#!/bin/ksh
retVal=`sqlplus -s user/passwd@oracle_sid <<EOF
SET SERVEROUTPUT ON SIZE 100000
DECLARE
STATUS_VALUE CHAR;
BEGIN
SELECT temp1 INTO STATUS_VALUE FROM sai;
DBMS_OUTPUT.PUT_LINE(STATUS_VALUE);
END;
/
SET SERVEROUTPUT OFF
exit;
EOF`
echo $retVal


& the o/p on console is

N PL/SQL procedure successfully completed.

whereas temp1 is a flag...& its value is either Y or N.

My requirement is ...how to get only 'N' or 'Y' in retVal??

i dont want the later part(PL/SQL procedure successfully completed.)

pls HELP. TIA.

If the first token of the output is either N or Y, can't you just ignore the rest?

Code:

case $retVal in Y\ *) echo yes;; N\ *) echo no;; esac
# or
retValReal=${retVal%\ *)  # or %% if your shell has that