Select Code to Download

TABLE SEARCH_CLASSIFIEDS
    FILENAME  VARCHAR(40)
    FIRST50CHARS  VARCHAR(50)
    PUB_DATE  DATE

SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( filename_list )
SORT BY FIRST50CHARS

CREATE TABLE CLS_TMP_$$
    FILENAME  VARCHAR(40)
NOLOGGING

SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( SELECT FILENAME FROM CLS_TMP_$$ )
SORT BY FIRST50CHARS

foreach (@files) {
  # INSERT INTO CLS_TMP_$$ values('$_')
}