Search code examples
plsqloracle-sqldeveloperplsqldeveloper

How to round number in PL-SQL?


I want to round a number in PL-SQL.

the number: 56.84923552

expected round: 56.849236

I want to round the 6th digit after the point. How can I do this in sql developer (PL-SQL)?


Solution

  • You need round:

    round(56.84923552, 6)
    

    gives

    56.849236