CREATE TABLE TRANSACTIONS (transaction_type_code VARCHAR2)

How many distinct transaction types are used in the transactions?
SELECT COUNT(DISTINCT transaction_type_code) FROM TRANSACTIONS
SELECT COUNT(DISTINCT "transaction_type_code") FROM "TRANSACTIONS"