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.
>

If the SQL itself is bad, the database will throw an error: e.g.

   > select * from amployees where employee_id is null;    > ORA-00942: table or view does not exist

//Walt Received on Tue Mar 13 2007 - 08:33:21 CDT