Hexadecimal value

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
User avatar
MuLtAnI
Moderador
Moderador
Posts: 90
Joined: Tue, 01 Jun 2004 9:21 am
Location: Videira - SC
Contact:

Hello everyone, I could not find a function to return the hexadecimal value of a number or a string in Oracle 8.0.5

Does anyone know?!?!
Fabiano
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 5
Joined: Wed, 23 Jun 2004 2:18 pm

And face, try to use to_char, but in the first parameter you indicate with an 'x' (which indicates a hexadecimal) the number of digits ...
would be like this:

[0]]

I hope I have helped ...

falows ...
User avatar
MuLtAnI
Moderador
Moderador
Posts: 90
Joined: Tue, 01 Jun 2004 9:21 am
Location: Videira - SC
Contact:

Dude I tried:

Select all

ORA-01481: modelo inválido de formato de número
This version 8.0.5 I think it does not support this formatting ...




Thanks for the attention!

[] 's
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

If this helps, but if your application is in forms, there is a command of the forms that does this using the d2kwutil library.

Select all

var_numerica := Win_API_Bitop.HexString_To_Number('12A');
The variable will receive the number 298.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 13 guests