please help me to hw the output of the belw statement is 1200?
-
What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL; i came to knw the answer as 1200 hw?
If places is positive, number is truncated to places decimal places. If places is negative, number is truncated on the left of the decimal point so in ur case the number on the left of the decimal point is 1234 -2 = Number of decimal places used for truncating so u have to truncate 1234 for two places that means 1200
sdf
-
What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL; i came to knw the answer as 1200 hw?
I believe the following is correct: SELECT TRUNC(1234.5678, 2) = 1234.5600 SELECT TRUNC(1234.5678, 1) = 1234.5000 SELECT TRUNC(1234.5678, 0) = 1234.0000 SELECT TRUNC(1234.5678, -1) = 1230.0000 SELECT TRUNC(1234.5678, -2) = 1200.0000 Seeing a pattern yet?
topcoderjax - Remember, Google is your friend.