is number

hello , everyone here

I have a table like following:

Ex_table

id        value
01        aaa
hh        AAA
02        bbb
ab        ccc

I'd like to insert a row whose id is max(to_number(id))+1 into this table . In this case , the id should be 3. But to_number('ab') will cause a error.How can I achieve it by only a SQL command.

Thanks in advance.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 14 2000 - 01:10:25 CDT