Converting decimal values to non decimal in computed column in oracle sql

Question

I am trying to convert decimal values into non decimal number for a computed column in Oracle SQL.

Please see the below code. But I am not able to get the desired output. Query:

Select cast(cost_account)*100/cast(amnt_fin) as "computed_LTV" 
From Loan_app.

Here I Want a new column name as computed_LTV with the required calculation with no decimal in the output.

question from:https://stackoverflow.com/questions/66063392/converting-decimal-values-to-non-decimal-in-computed-column-in-oracle-sql

Answer 1

It is ROUND you're looking for, I presume.

SELECT ROUND (cost_account * 100 / amnt_fin) AS "computed_LTV" FROM Loan_app