gistfile1.sql

-- I want my code to be backwards compatible with database versions

SELECT COUNT(*)
INTO has_new_col
FROM all_tab_cols
WHERE table_name = 'UPDATED_TABLE'
AND column_name = 'NEW_COL';

IF has_new_col = 0 THEN
    INSERT INTO other_table
    (
        other_table_sid,
        old_col
    )
    SELECT other_table_sid,
           old_old
    FROM updated_table;
ELSE
    INSERT INTO other_table
    (
	    other_table_sid,
	    old_col,
	    new_col
    )
    SELECT other_table_sid,
           old_col,
           new_col   -- Gives PL/SQL: ORA-00904: "NEW_COL": invalid identifier :(
    FROM updated_table;
END IF;