Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to see what’s really stored in the database?

April 26, 2017database stored

0

Posted

How to see what’s really stored in the database?

1 Answer

0

Posted

To find the real numeric value for a character stored in the database use the dump command: The syntax of the function call is: DUMP( [, [, [, ] ] ] ) where: value – is the value to be displayed format – is a number which describes the format in which bytes of the value are to be displayed: 8 – means octal, 10 – means decimal, 16 – means hexadecimal; other values between 0 and 16 mean decimal; values greater then 16 are a little confusing and mean: print bytes as ASCII characters if they correspond to printable ASCII codes, print them as “^x” if they correspond to ASCII control codes and print them in hexadecimal otherwise; adding 1000 to the format number will add character set information for the character data type values to the return value offset – is the offset of the first byte of the value to display; negative values mean counting from the end length – is the number of bytes to display. So for example, SQL> SELECT DUMP(col,1016)FROM table; Typ