Oracle TO_NUMBER Function

preview_player
Показать описание

The Oracle TO_NUMBER function is used to convert a text value into a number value.

It’s similar to TO_CHAR and TO_DATE, but converts a value to a number.
Рекомендации по теме
Комментарии
Автор

How would you convert a UUID like to a number?

FamilyGuySweden
Автор

Hi friend!! How can I put letters in a TO_NUMBER or TO_CHAR function? Nice video!!

Huguito
Автор

can you please remove your advertising from the video, you cant even see the result.

mohammedbougayou
Автор

select to_number('5131427328503192') from dual

output:5.13142732850319E15, how I can get the original number 5131427328503192 as my output instead of a exponential number, i think as the number is more than 15 digit it is creating this problem, is there any way this can be fixed

alokjyotibal