Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Why do I get binary dumps as output (Read 2734 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Why do I get binary dumps as output
26.10.05 at 11:26:32
 
A customer asked the following question today:
 
Question:
When I run select saddr from v$session I get the output as:
0000  02 00 25 00 D9 00 38   -                         ..%...8
 
What does this mean? When I run it in SQL*Plus I get 0225D938
 
Answer:
When SQL*XL needs to output binary data it will dump the data in this format. The saddr column is defined as raw(4) in the database. It is a binary value. SQL*Plus represents the output in hexadecimals 02 25 D9 38.  
 
The SQL*XL output contains three fields:
 
offset Values                                                   Text representation
0000  02 00 25 00 D9 00 38   -                         ..%...8
 
The offset is the offset from the beginning of the data.
The values are the hexadecimal representation of each byte of data
The text representation displays a . if the hex value is not a printable character and it will show the printable character in other cases.  
 
In our example 02 and 00 are not printable characters. 25 corresponds to a % sign and 38 corresponds to the number 8.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1