In Column "A" i have list of dates. For eg: starting from A2:A16. The dates are in the format 'MM/DD/YYYY' in the cell.
Now i would like to get the DT_KEY value of the date from each cell by querying into the database.

When i get the DT_KEY directly from Database i use the below query.
SQL:
select DT_KEY from date_table
where CAL_DT = TO_DATE('1/15/1945 00:00:00', 'MM/DD/YYYY HH24:MI:SS')
Output:123456789

Kindly provide me the code which will automatically pass the date to the above SQL from the cells in 'A' column one by one and will get the DT_KEY and then insert it into 'B' column