Загрузка данных


SELECT
    code,
    length(code) AS code_length,
    CASE
        WHEN length(code) <= 50 THEN 'OK'
        ELSE 'TOO LONG'
    END AS status
FROM (
    VALUES
        ('CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_INV_TO_STR'),
        ('CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_STR_TO_INV'),
        ('ANNUAL_PAYMENT_ASV'),
        ('TRANSFER_FROM_RESERVE_TO_ACCOUNT_OF_OUTSTANDING_DEBTS'),
        ('REFUSAL_BANK')
) v(code);