Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL Loader Concatenate date and time

SQL Loader Concatenate date and time

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 29 May 2003 07:54:43 -0800
Message-ID: <F001.005A5987.20030529075443@fatcity.com>


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: bmetelsky_at_cps92.com

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: ListGuru_at_fatcity.com (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).
Received on Thu May 29 2003 - 10:54:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US