select
    item_code ITEM_CODE
    ,substr(trim(item_name), 1, 10) ITEM_NAME
from
    tbl_item
order by
    item_code desc
;