Need help with displaying raw data

From: Rich Gugel <rich.gugel_at_doa.state.wi.us>
Date: 8 Mar 2004 10:13:18 -0800
Message-ID: <4999ceb3.0403081013.ce9933f@posting.google.com>

Perhaps this has already been done, but I have not been able to find it. I want to display out the values of low-value and high-value which are raw data type in a readable format. For example the hire date would display as 30-sep-2004 instead of 7865091E010101 Oracle 9i by the way. How to I get the following query to display correctly?

I created a table

CREATE TABLE emp (empno NUMBER CONSTRAINT pk_emp PRIMARY KEY, ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER,
hiredate DATE DEFAULT SYSDATE,

sal NUMBER(10,2) CONSTRAINT ck_sal CHECK (sal > 500), 
comm NUMBER(9,0) DEFAULT NULL, 
deptno NUMBER(2)CONSTRAINT nn_deptno NOT NULL) 

PCTFREE 5 PCTUSED 75; Inserted a couple of rows

INSERT INTO EMP (EMPNO,ENAME, Job,mgr, hiredate, sal, comm, deptno) VALUES(1,'Fred','Cabbie',1,'22-feb-2004',500.01,1,2); INSERT INTO EMP (EMPNO,ENAME, Job,mgr, hiredate, sal, comm, deptno) VALUES(2,'Jim','Mechanic',3,'30-sep-2001',600.01,2,9);

Then analyzed

ANALYZE TABLE EMP COMPUTE STATISTICS FOR TABLE FOR ALL COLUMNS; Would like to see the low-value and high-value displayed in a pretty format.

ATTRIBUTES                     HIGH_VALUE         LOW_VALUE
------------------------------ ------------------ ------------------
EMP
   EMPNO NUMBER NOT NULL	 C103               C102
   ENAME VARCHAR2(10)          4A696D             46726564
   JOB VARCHAR2(9)             4D656368616E6963   436162626965
   MGR NUMBER                  C104               C102
   HIREDATE DATE               78680216010101     7865091E010101
   SAL NUMBER(10,2)            C2070102           C2060102
   COMM NUMBER(9,0)            C103               C102
   DEPTNO NUMBER(2,0) NOT NULL C10A               C103

8 rows selected. Received on Mon Mar 08 2004 - 12:13:18 CST