Re: TO_NUMBER() question

From: Peter Laursen <pl_at_mail1.remove.this.stofanet.dk>
Date: Mon, 24 Sep 2001 17:14:49 +0200
Message-ID: <3baf4ee1$0$14817$ba624c82@nntp02.dk.telia.net>

> SELECT text text_value,TO_NUMBER(text) number_value FROM
>my_table;
>
> If my_table.text is numeric, there's no problem. However,
if
>it's not numeric, I get an ORA-01722.
>

You could write your own function. It would slow down your select somewhat.

CREATE OR REPLACE function to_number_null (a varchar2) return number
as
begin
  return to_number(a);
exception
  when others then
  return null;
end;

/Peter Received on Mon Sep 24 2001 - 10:14:49 CDT