First Column in the below ASCII table represents Control Codes which are non-printable
Tip:
To know the ASCII value of characters in a table column ,Use DUMP function.
DUMP(<value> [,<return_format>[,<start_position>[,<length>]]])
Ex: SELECT PRODUCT_DESC,dump(PRODUCT_DESC) from W_PRODUCT_D;
NO. 40_DRILL, JOBBER_SOLID CARBIDE_ RSC0.0980ST
Typ=1 Len=47: 78,79,46,32,52,48,95,68,82,73,76,76,44,32,74,79,66,66,69,82,95,83,79,76,73,68,32,67,65,82,66,73,68,69,95,30,82,83,67,48,46,48,57,56,48,83,84
SELECT dump(PRODUCT_DESC,8) from W_PRODUCT_D –Returns Octal format
lly below numbers can be used to display in various formats
Tip:
To know the ASCII value of characters in a table column ,Use DUMP function.
DUMP(<value> [,<return_format>[,<start_position>[,<length>]]])
Ex: SELECT PRODUCT_DESC,dump(PRODUCT_DESC) from W_PRODUCT_D;
NO. 40_DRILL, JOBBER_SOLID CARBIDE_ RSC0.0980ST
Typ=1 Len=47: 78,79,46,32,52,48,95,68,82,73,76,76,44,32,74,79,66,66,69,82,95,83,79,76,73,68,32,67,65,82,66,73,68,69,95,30,82,83,67,48,46,48,57,56,48,83,84
SELECT dump(PRODUCT_DESC,8) from W_PRODUCT_D –Returns Octal format
lly below numbers can be used to display in various formats
8 | Octal |
10 | Decimal |
16 | Hexidecimal |
17 | Single Characters |
1008 | octal notation with the character set name |
1010 | decimal notation with the character set name |
1016 | hexadecimal notation with the character set name |
1017 | single characters with the character set name |
No comments:
Post a Comment