Can I view a column/row in hex?

[psneeley]

Is there a way to view the contents of a row/column (the result set yielded from an sql query) in Hex? I have a apparently 'Blank' or 'NULL' column but at least some of the fields must have special characters that I can't see.

 

[Marco Kalter]

Perhaps you can use the SQL function "dump". For example:

SQL> select ename, dump(ename) from emp;

ENAME      DUMP(ENAME)
---------- --------------------------------------------------------------------------------
SMITH      Typ=1 Len=5: 83,77,73,84,72
ALLEN      Typ=1 Len=5: 65,76,76,69,78
WARD       Typ=1 Len=4: 87,65,82,68
JONES      Typ=1 Len=5: 74,79,78,69,83
MARTIN     Typ=1 Len=6: 77,65,82,84,73,78
BLAKE      Typ=1 Len=5: 66,76,65,75,69
CLARK      Typ=1 Len=5: 67,76,65,82,75
SCOTT      Typ=1 Len=5: 83,67,79,84,84
KING       Typ=1 Len=4: 75,73,78,71
TURNER     Typ=1 Len=6: 84,85,82,78,69,82
ADAMS      Typ=1 Len=5: 65,68,65,77,83
JAMES      Typ=1 Len=5: 74,65,77,69,83
FORD       Typ=1 Len=4: 70,79,82,68
MILLER     Typ=1 Len=6: 77,73,76,76,69,82

 

[psneeley]

Thanks! That looks like it will do the trick.

 

[juanian]

I love reading these boards! I had a column that I suspected had a null character, but the Hex view of the PL/SQL Developer 'Large Data Editor' didn't show anything unusual. The SQL Dump() did show the null character! (Hmm, is there any way for the Hex view to be able to show null characters?!?)

THANKS for the tip!