As shown in figure, want to let count values to display the data in the science of the

CodePudding user response:

SELECT TO_CHAR (51920, 'EEEE 9.99')
The FROM DUAL;

CodePudding user response:

SELECT
TO_CHAR (0.000000000000097, 'EEEE 9.9) digital turn scientific notation,
TRUNC turn scientific notation (9.7 e+14, 128), digital
The FROM DUAL;

CodePudding user response:

refer to the second floor AHUA1001 response:

SELECT
TO_CHAR (0.000000000000097, 'EEEE 9.9) digital turn scientific notation,
TRUNC turn scientific notation (9.7 e+14, 128), digital
The FROM DUAL;

thank you!

CodePudding user response:

reference 1st floor ZJHZ_ leaf response:

SELECT TO_CHAR (51920, 'EEEE 9.99')
The FROM DUAL;