Posts by Diego Simôes da Silva • 31 points
2 posts
-
3
votes2
answers37
viewsQ: Why does To_char(3E4) not result in '3E4'?
Guys like me convert an exponential number (NUMBER) to string (VARCHAR) but it is expressed equal?? Example: SQL> SELECT TO_CHAR (NUMERO) NUMCONVERT 2 FROM (SELECT 3E4 NUMERO FROM DUAL);…
-
0
votes0
answers265
viewsQ: How not to convert an exponential number to decimal?
Guys I’m having the following problem: I created a function to put the thousand point(s) in the values you receive as parameter (VARCHAR2). This function takes integer values and values of type…