FAQ
Hi,

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).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 21, '01 at 2:44a
activeMar 21, '01 at 2:44a
posts1
users1
websiteoracle.com

1 user in discussion

Muru: 1 post

People

Translate

site design / logo © 2022 Grokbase