Re: Division by zero: how to handle?

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote:
> Try this which works, you get the error message but the script continues
> onwards :
>
> SQL>ed fred.sql
>
> whenever sqlerror continue none
>
> select 1/1 from dual;
> select 'ok' from dual;
> select 1/0 from dual;
> select 'finished' from dual;
> <exit editor & save>

Is there something like that for within a single query?

select 1/(rownum-5) from tab; -- as a user with > 5 tables

The whole query aborts, rather than just ignoring the row that would have an error.

regards,

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB