SELECT DISTINCT category_set_id||category_name ID, category_name VALUE FROM msc_item_categories UNION ALL SELECT 'NA' ID, 'Not Categorized' VALUE FROM dual
View Text - HTML Formatted
SELECT DISTINCT CATEGORY_SET_ID||CATEGORY_NAME ID , CATEGORY_NAME VALUE FROM MSC_ITEM_CATEGORIES UNION ALL SELECT 'NA' ID , 'NOT CATEGORIZED' VALUE FROM DUAL