You Asked

For example, My query is following
input data is in number format :- 123.456
and I want to see 123.45.
Not need round off.

and Connor said...

A trunc will take care of it

SQL> select to_char(trunc(123.456,2)) from dual;

TO_CHA
------
123.45

Is this answer out of date? If it is, please let us know via a Comment

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL reference manual from the Oracle documentation library