Database » Ask Tom MOST RECENT ARTICLES » Converting CHAR to Numeric via user written function

Feeds

15142 items (92 unread) in 26 feeds

Database (92 unread)

• DBA's notes (6 unread)
• $Pete Finnigan's Oracle security weblog (1 unread)
• Ask Tom MOST RECENT ARTICLES (38 unread)
• Databases News (3 unread)
• DBAzine.com - Oracle Articles Archive
• Eddie Awad's Blog (3 unread)
• FeuerThoughts (1 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog
• MySQL Performance Blog (9 unread)
• Niall's Oracle Pages
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions
• Oracle Security Alerts
• Oracle Software Downloads
• Oracle Technology News
• Oracle's OTN TechCasts (2 unread)
• Orawin.Info
• OTN TechBlog
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (3 unread)
• TheServerSide.com (26 unread)
• Upcoming Security Alerts

Ask Tom MOST RECENT ARTICLES

• September 04, 2008
• 

  Converting CHAR to Numeric via user written function

  Fetched: September 4th, 2008, 9:41pm PDT

  Tags:    [edit]

  Hi Tom, We use the following function to convert numbers in CHAR format to numeric. The data is very dirty so if it can't convert or you get "infinity" we just put in a zero. We run in parallel over billions of rows. It used to be quite slow un...