CREATE TABLE table_name_8 (bore VARCHAR2, designation VARCHAR2)

What is the bore of the boat howitzers with a 12-pdr heavy designation?
SELECT bore FROM table_name_8 WHERE designation = "12-pdr heavy"
SELECT "bore" FROM "table_name_8" WHERE "12-pdr heavy" = "designation"