CREATE TABLE table_name_46 (date VARCHAR2, tie_no VARCHAR2)

what is the date when the tie no is 9?
SELECT date FROM table_name_46 WHERE tie_no = "9"
SELECT "date" FROM "table_name_46" WHERE "9" = "tie_no"