OraFAQ Forum: SQL & PL/SQL » How to convert a string into numeric other than to

Home » SQL & PL/SQL » SQL & PL/SQL » How to convert a string into numeric other than to_number (11)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to convert a string into numeric other than to_number [message #573524]

Sun, 30 December 2012 09:06

cplusplus1
Messages: 30
Registered: October 2012
Location: usa

Member

I have a column which has has all numeric values 3 digits to 7 digits in length but all in string format, I want to use seomthing other than to_number function.

Would like to use within the ETL tool, where to_number function isn't getting recognized.

select EMP_NO from employees;

Thank you very much for the helpful info.

Report message to a moderator

Re: How to convert a string into numeric other than to_number [message #573525 is a reply to message #573524]

Sun, 30 December 2012 09:14

Littlefoot
Messages: 16995
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Reviewing your previous topics, it appears that your ETL tool (what is its name?) doesn't support SUBSTR, doesn't have TO_NUMBER, has problems with LIKE ... why don't you use some decent ETL tool, instead?

As of your question: Oracle is capable of performing implicit conversion between different datatypes, so - maybe you don't have to do anything.

Report message to a moderator

Re: How to convert a string into numeric other than to_number [message #573534 is a reply to message #573524]

Sun, 30 December 2012 09:43

flyboy
Messages: 1670
Registered: November 2006

Senior Member

In Oracle you may also use CAST function, which is for 11gR2 documented here: http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions023.htm#i1269136

select cast( '1234' as number(10) ) from dual;

but I doubt your ETL tool supports it.
Maybe it would be faster to explore what is "getting recognized" in that tool and stop trying to do anything else there.

Report message to a moderator

Previous Topic:	Extract Absent days from the month
Next Topic:	Need a little help in deriving the logic

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 13:29:02 CDT 2013

Total time taken to generate the page: 0.65020 seconds