Can SQL*Loader do this?

From: Snewber <snew_at_snewx.com>
Date: Mon, 22 Aug 2005 16:23:58 +1000
Message-ID: <debr1u$1rsj$1_at_bunyip2.cc.uq.edu.au>

[Quoted] I'm trying to load the contents of a flat text file into an oracle database (9.2.0.5 on Solaris).

I need to transform the file contents from this file:

##########################


# 20-08-2004 00:00:00


# DB Name       Size in Mb


A               1
B               2
C               3
##########################


# 21-08-2004 00:00:00


# DB Name       Size in Mb


A               4
B               5
C               6

to this table:

DATE                DB_NAME SIZE
20-08-2004 00:00:00 A       1
20-08-2004 00:00:00 B       2
20-08-2004 00:00:00 C       3
21-08-2004 00:00:00 A       4
21-08-2004 00:00:00 B       5
21-08-2004 00:00:00 C       6

Thanks in advance Received on Mon Aug 22 2005 - 08:23:58 CEST