There is a table (test)
Id item (varchar2) amout (int)

1 12 2
2, 12.12 3
3 12.12.8 2
4 12.12.8.1 4



The select fuc (amount) from the item='12.12.8.1'
The output of 48

The select fuc (amount) from the item='12.12.8'
The output of 12

The select fuc (amount) from the item='12.12'
Output 6

The select fuc (amount) from the item='12'
Output 2