Re: regarding sql

dutt wrote:
> I had an sql statement for example
>
> select * from employees where employee_id is null
>
> the o/p will be no rows returned.
>
> Now my doubt is whether the feedback we are getting is due to
>
> failure of sql statement or no records are found for the matching
> condition
>
> In detail,
>
> is there any relation between failure of sql statement and no records
> found.

In PL/SQL there is a specific named exception for this condition:

SELECT dummy
FROM dual
WHERE dummy = 'A';

DECLARE
  s STRING(5);
BEGIN
   SELECT dummy
   INTO s
   FROM dual
   WHERE dummy = 'A';
END;
/

Is that what you are seeing?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org