Help for this page

Select Code to Download


  1. or download this
    TABLE SEARCH_CLASSIFIEDS
    FILENAME  VARCHAR(40)
    FIRST50CHARS  VARCHAR(50)
    PUB_DATE  DATE
  2. or download this
    SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( filename_list )
SORT BY FIRST50CHARS
  3. or download this
    CREATE TABLE CLS_TMP_$$
    FILENAME  VARCHAR(40)
NOLOGGING
  4. or download this
    SELECT FILENAME FROM SEARCH_CLASSIFIEDS
WHERE FILENAME IN ( SELECT FILENAME FROM CLS_TMP_$$ )
SORT BY FIRST50CHARS
  5. or download this
    foreach (@files) {
  # INSERT INTO CLS_TMP_$$ values('$_')
}