1.

How To Enter Characters As Hex Numbers?

Answer»

If you want to enter CHARACTERS as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (Ox). A HEX number STRING will be automatically converted into a CHARACTER string, if the expression context is a string. Here are some good EXAMPLES:

SELECT X313233’ FROM DUAL; 123 SELECT 0x414243 FROM DUAL; ABC

If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (Ox). A HEX number string will be automatically converted into a character string, if the expression context is a string. Here are some good examples:



Discussion

No Comment Found