We asked you to use this block to determine your answer:
DECLARE multiplier INTEGER := /*VALUE*/; BEGIN FOR indx IN 1 .. 5 LOOP DBMS_OUTPUT.put_line ( 'Trunc by ' || NVL (TO_CHAR (multiplier * indx), 'NULL') || ' = ' || TO_NUMBER (TRUNC (123456.123456, multiplier * indx))); END LOOP; END;And this is what he wrote:
Well, I must admit: that was a typo. And a lucky typo....it did not affect the outcome of the quiz, because Oracle ending up "doing the right thing" for us through implicit conversions.
So I am going to change the quiz to use TO_CHAR. Thanks for pointing this out, Kim!