Oracle SQL按字符数拆分字符串字段并在末尾追加一个字母

SELECT 
    text_field,
    CONCAT(SUBSTR(text_field, 1, 5), 'A') AS part1,
    CONCAT(SUBSTR(text_field, 6, 5), 'A') AS part2,
    -- 以此类推，根据需要拆分更多部分
    CONCAT(SUBSTR(text_field, LENGTH(text_field) - 4, 5), 'A') AS last_part
FROM 
    example_table;

SELECT 
    text_field,
    SUBSTR(text_field, 1, 5) || 'A' AS part1,
    SUBSTR(text_field, 6, 5) || 'A' AS part2,
    -- 以此类推，根据需要拆分更多部分
    SUBSTR(text_field, LENGTH(text_field) - MOD(LENGTH(text_field), 5) + 1, MOD(LENGTH(text_field), 5)) || 'A' AS last_part
FROM 
    example_table;

SELECT 
    text_field,
    CASE WHEN LENGTH(text_field) >= 5 THEN SUBSTR(text_field, 1, 5) || 'A' ELSE text_field || 'A' END AS part1,
    -- 以此类推，根据需要拆分更多部分
    CASE WHEN LENGTH(text_field) > 5 THEN SUBSTR(text_field, LENGTH(text_field) - 4, LENGTH(text_field)) || 'A' ELSE text_field || 'A' END AS last_part
FROM 
    example_table;