Char to Int

Hello2Lu · #1 (**permalink**) 10-13-03, 09:08

Hello,

can you explain to me how to convert a String to a number in a select statement with oracle RDB

Thanks in advance!

andrewst · #2 (**permalink**) 10-13-03, 13:34

TO_NUMBER(string)

Hello2Lu · #3 (**permalink**) 10-14-03, 02:06

Thanks for your response, but it don't work, probably because Oracle RDB

Error message :

Error: %SQL-F-RTNNOTDEF, function or procedure TO_NUMBER is not defined (State

1000, Native Code: FFFFFFFF)

Hello2Lu · #4 (**permalink**) 10-14-03, 04:04

With the CAST functon that's working

select cast(substring(arbores_id from 6 for 5) as integer)+1 from t_arborescence

Thanks for all.

Internet Services

Web Development

Digital Marketing

Consumer Tech