How to convert full-width numbers to half-width numbers in Oracle

It is believed that many inexperienced people don't know what to do about how to convert full-width numbers into half-width numbers in Oracle. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Database table test field id name age

Full-width number: 1234

Half-width number: 1234

The difference between length and lengthb:

Length (1234) 4

Lengthb (1234) 8

Usage of to_single_byte function:

To_single_byte (1234) 1234

Find all full-width numbers:

Select age from test where lengthB (age) > 4

Replacing full-width with half-width:

Update test T1 set t1.age = (select to_single_byte (t2.age) from test T2 where t1.id = t2.id)

After reading the above, have you mastered the method of converting full-width numbers to half-width numbers in Oracle? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!