SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use Ltrim instr function for a decimal number

2894044Jan 12 2020 — edited Feb 12 2020

Hi All,

In a field I get values like
35.0945,
15.547,
152.473
I need to use a expression in such a way that . I need to get all the numbers before decimal and after decimal just the first digit.

Solution for the above field
35.0,
15.5,
152.4

Any help much appreciated
Thankyou
Pradnya

Added on Jan 12 2020

9 comments

713 views