CREATE TABLE table_name_47 (opponent_in_the_final VARCHAR2, date VARCHAR2)

On October 14, 1996 who was the opponent in the final?
SELECT opponent_in_the_final FROM table_name_47 WHERE date = "october 14, 1996"
SELECT "opponent_in_the_final" FROM "table_name_47" WHERE "date" = "october 14, 1996"