I need to find whether SYSDATE falls between beginning
date and ending date while loading data from a flat
file. I searched Oracle manuals and Metalink, could
not find a clue. Is this possible at all? If so how?
example:
LOAD DATA
INFILE 'price.dat'
INTO TABLE price
WHEN TRUNC(SYSDATE) BETWEEN price_beg_date AND
price_end_date
(
price_code POSITION(1:3) CHAR
amount POSITION(4:7) INTEGER
price_beg_date POSITION(8:16) DATE 'MMDDRRRR'
price_end_date POSITION(16:24) DATE 'MMDDRRRR'
)
price.dat
AAA10000318200103182002
BBB20000318200003182001
While loading the above, only the first record should
get inserted. We can use a temporary table to load all
records and filter to final table using SQL, but the
data is huge and so filtering while loading would be a
better option.
Any help is highly appreciated.
Thanks
Muru
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Muru
INET: muru_oracle_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).