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

显示全部楼层 · 2008-2-13 12:43:03

SQL> select ename,dump(ename) from scott.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
请问一下，DUMP是做什么用的？Typ=1 Len=5: 83,77,73,84,72这些又如何解释？

千问 · 2008-2-13 12:43:03

DUMP returns a VARCHAR2 value containing the datatype code, length in bytes, and internal representation of expr. The returned result is always in the database character set.

千问 · 2008-2-13 12:43:03

谢谢，已经搞清楚了

SQL&gt; select ename,dump(ename) from scott.emp;

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