Results 1 to 4 of 4

Thread: Char to Int

  1. #1
    Join Date
    Jun 2002
    Location
    BE
    Posts
    4

    Unanswered: Char to Int

    Hello,

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

    Thanks in advance!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Char to Int

    TO_NUMBER(string)

  3. #3
    Join Date
    Jun 2002
    Location
    BE
    Posts
    4
    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 (State1000, Native Code: FFFFFFFF)

  4. #4
    Join Date
    Jun 2002
    Location
    BE
    Posts
    4
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •