DECODE Question

From: Systems Admin <sysadmin_at_doj.vic.gov.au>
Date: 1996/11/07
Message-ID: <55roe8$g6c_at_news.mel.aone.net.au>#1/1

I have a column called DISK_NAME which is a VARCHAR2(22). It contains data in the following form:

DISK_NAME

---

(dgsc(vme(0),1,7),0,0)
(dgsc(vme(0),1,7),0,1)
(dgsc(vme(0),1,7),0,2)
(dgsc(vme(0),1,7),0,3)
(dgsc(vme(0),1,7),0,4)
(dgsc(vme(0),1,7),0,0)
(dgsc(vme(0),1,7),0,1)
(dgsc(vme(0),1,7),0,2)
(dgsc(vme(0),1,7),0,3)
(dgsc(vme(0),1,7),0,4)
(dgsc(vme(0),1,7),0,0)

I want to load this with SQL*Loader and want to decode it before it hits the table, so I tried this in the CTL file : Received on Thu Nov 07 1996 - 00:00:00 CET