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: [EMAIL PROTECTED] 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: [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).
