C:OracleOra81BIN>type osscr.ksh
sqlplus -s tricore/password@larch_prod @scr
if [[ $? -eq 1 ]]
then
        echo "Data found"
else
        echo  "No data found"
fi

----------------------------------------------------------------------

C:OracleOra81BIN>type scr.sql
variable b number
declare
name varchar2(10);
jo   varchar2(10);
begin
select ename,job into name,jo from emp where empno=&empno;
dbms_output.put_line(name||','||jo);
:b :=1;
Exception
        when no_data_found then
        :b :=2;
end;
/
exit :b;

----------------------------------------------------------------------

C:OracleOra81BIN>ksh
$ ./osscr.ksh
Enter value for empno: 7369
old   5: select ename,job into name,jo from emp where empno=&empno;
new   5: select ename,job into name,jo from emp where empno=7369;

PL/SQL procedure successfully completed.

Data found
$ ./osscr.ksh
Enter value for empno: 993
old   5: select ename,job into name,jo from emp where empno=&empno;
new   5: select ename,job into name,jo from emp where empno=993;

PL/SQL procedure successfully completed.

No data found
$