Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Getting the max of a char field
Hi,
I have a table T1 and column c1 that is a char, but contains integers.
What I want, is to get the max of these values:
"select to_num(c1) from T1" gives me the integer values
"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"
Has anybody any idea how to get this max? Thanks Received on Fri Nov 26 1999 - 02:54:05 CST