Skip to content
Advertisement

Tag: chr

Oracle chr() diferent returns from SQL engine versus PL/SQL engine, why?

Same function, same argument, different outputs: PL/SQL procedure successfully completed. Answer In your case, chr() appears to be performing an implicit conversion to binary_float (IEEE 754 floating-point representation) as the datatype, as opposed to number (ANSI SQL NUMERIC). This results in different rounding results. I cannot duplicate your results on 19c unless I force the datatype, in which case I

Advertisement