All
Im need to concatenate my log_date and log_time field (the 2
physical records into one logical record).
I can find how to do it with a fixed length file but my case is a
delimited file. Looking at the docs, it seems the continueif is used for
delimited dtaa, I cant seem to get the syntax to work
any ideas would be welcome ;-)
thanks!
Bob
LOAD DATA
INFILE 'F:\528log.txt'
BADFILE 'F:\bad.txt'
truncate
INTO TABLE log
FIELDS TERMINATED BY WHITESPACE OPTIONALLY enclosed by '"'
TRAILING(
log_id INTEGER,
log_date DATE 'DD-MON-YYYY',
log_time char,
vpn_type char,
interface char,
name char,
type char,
action char,
service char,
source char,
destination char,
protocol char,
port char,
service2 char,
log_user char,
message char)
example source row data
"283700" "28May2003" "16:28:12" "fff" "eth-sfp1c0" "fff" "Log" "Accept"
"nbdatagram" "10.54.4.1" "10.54.255.255" "udp" "23" "nbdatagram" "" ""
Example oracle row data
283700 05/28/2003 00:00:00 16:28:12 fff eth-s4fp1c0
fff Log Accept nbdatagram 10.54.4.1 10.54.255.255
udp 23 nbdatagram
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
