How the oracle database number type number plus micrometer operators and then stored into the number/type of column

CodePudding user response:

Micrometer operator (scientific notation), is just a display format, in fact number does not contain a comma,

So can't add a comma, and then back to number character, can only endure to varchar field,

CodePudding user response:

The number changes varchar type cannot save a comma

CodePudding user response:

Can't, not if you just want to see in PLSQL query micrometer, can modify the number of the PLSQL type display format