Value in hexadecimal

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Thu, 28 Oct 2004 2:46 pm

Hello guys, I couldn't find a function to return the Hexadecimal value of a number or a string in Oracle 8.0.5 does anyone know?!?!
Location: Videira - SC

Poston Thu, 28 Oct 2004 4:39 pm

aí guy, tries to use to_char, but in the second parameter you indicate with an ' x ' (which indicates a hexadecimal) number of digits ... would be like this: select to_char (' 10 ', ' xx ') from dual I hope I helped ...

Falows ...

Poston Wed, 03 Nov 2004 4:58 pm

dude I tried: ORA-01481: invalid number format template this version 8.0.5 I don't think supports this formatting ... anyway thanks for listening!

[] 's
Location: Videira - SC

Poston Fri, 19 Nov 2004 7:36 am

Not if that helps, but IF your application is in FORMS, there is a command of the Forms that does so using the d2kwutil library.

Code: Select all
var_numerica := Win_API_Bitop.HexString_To_Number('12A');
the variable receives the number 298.
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Return to SQL

Who is online

Users browsing this forum: No registered users and 6 guests