Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PLSQL2000
-
Convert Cents to Dollars
Hello, I'm trying to convert cents to dollars, i.e add a decimal place. The problem I've encountered is that when the cents value is in hundreds, i.e. 100 cents = 1.00, it drops the .00 and just shows 1. Below is an example of how I'm trying to do this... Is there a better way to do this...- PLSQL2000
- Thread
- Replies: 2
- Forum: Oracle: All versions
