CREATE TABLE ref_colors (color_code CLOB, color_description CLOB)
CREATE TABLE ref_characteristic_types (characteristic_type_code CLOB, characteristic_type_description CLOB)
CREATE TABLE product_characteristics (product_id NUMBER, characteristic_id NUMBER, product_characteristic_value CLOB)
CREATE TABLE characteristics (characteristic_id NUMBER, characteristic_type_code CLOB, characteristic_data_type CLOB, characteristic_name CLOB, other_characteristic_details CLOB)
CREATE TABLE ref_product_categories (product_category_code CLOB, product_category_description CLOB, unit_of_measure CLOB)
CREATE TABLE products (product_id NUMBER, color_code CLOB, product_category_code CLOB, product_name CLOB, typical_buying_price CLOB, typical_selling_price CLOB, product_description CLOB, other_product_details CLOB)

What are the names, details and data types of the characteristics which are never used by any product?
SELECT characteristic_name, other_characteristic_details, characteristic_data_type FROM characteristics EXCEPT SELECT t1.characteristic_name, t1.other_characteristic_details, t1.characteristic_data_type FROM characteristics AS t1 JOIN product_characteristics AS t2 ON t1.characteristic_id = t2.characteristic_id
SELECT "characteristic_name", "other_characteristic_details", "characteristic_data_type" FROM "characteristics" EXCEPT SELECT "t1"."characteristic_name", "t1"."other_characteristic_details", "t1"."characteristic_data_type" FROM "characteristics" "t1" JOIN "product_characteristics" "t2" ON "t1"."characteristic_id" = "t2"."characteristic_id"