CREATE TABLE table_203_248 (id NUMBER, "code" CLOB, "year" NUMBER)

list each code not associated to a year .
SELECT "code" FROM table_203_248 WHERE "year" IS NULL
SELECT "code" FROM "table_203_248" WHERE "year" IS NULL