Re: Getting the max of a char field

Franz Mueller <nospam#####franz.mueller_at_orbis.de> wrote:

: "select max(to_num(c1)) from T1" or even "select max(NUM) from (select
: to_num(c1) NUM from T1)" gives me an error:
: "ORA-01722: invalid number"

Hi

It seems that you are trying to convert char to number with wrong format. For instance, the following statment will give you the same error:

SELECT to_number('1.1', '9,9') FROM dual;
                        ^^^^^^ 
                      this is bad format string

regards,
tema Received on Fri Nov 26 1999 - 03:29:22 CST