We all know that the irrational number π is a mathematical constant that is the ratio of a circle’s circumference to its diameter.

Most databases provide a built in function that can be used to display a representative value of PI. I thought it would be fun to check a few databases to see which one serves up the most accurate juiciest slice of PI by default!

MySQL returns 14 digits:

Oracle does not have a PI function, but we can simulate it using one of the following two techniques where the first one is more accurate to 8 digits: