CREATE TABLE table_name_87 (manner_of_departure VARCHAR2, date_of_appointment VARCHAR2)

I want the manner of departure for date of appointment being 12 october 2007
SELECT manner_of_departure FROM table_name_87 WHERE date_of_appointment = "12 october 2007"
SELECT "manner_of_departure" FROM "table_name_87" WHERE "12 october 2007" = "date_of_appointment"