Chapter 8. Working with Numbers
When is a number not a number? When it's a string, of course. Throughout the history of databases, developers and DBAs have had to grapple with numeric data that is presented as a string, and with the need to convert digits in text to a number data type. Beyond data type issues, numbers also present interesting problems of precision and size. Contemporary computers are fantastic at dealing with numbers on both a vast or miniscule scale, but at some point you'll likely need to deal with data infinitely larger or smaller than you expected. Perhaps one of the most subtle issues when working with numbers is the tension between humans counting in base 10, and computers using binary.
This chapter introduces a host of recipes ...
Get Oracle SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
