Без форматирования | SELECT c.code_value asAS "Значение кода" ,decode(C.LOAD_QUOTATION,
,DECODE (c.load_quotation, 'True', 'Да', 'Нет') asAS "Загружать котировку?" ,C.REQUEST_GROUP as
,c.request_group AS "Группа" ,
RMRP.PARAM_NAME as
,rmrp.param_name AS "Доп.атрибут. Название" ,
(decode(to_char(RCPV.PARAM_VALUE),
, (DECODE (TO_CHAR (rcpv.param_value), '4', 'ISIN', to TO_ charCHAR ( RCPVrcpv. PARAMparam_ VALUEvalue))) asAS "Доп.атрибут. Значение"
FROM codes c
join
JOIN code_param_values rcpv
ON on RCPV.CODE_ID=C.ID
joinrcpv.code_id = c.id
JOIN mu_request_params rmrp
ON on rmrp.param_id = rcpv.param_id
where WHERE c. TYPEtype_ IDid inIN (SELECT type_id
FROM RESMAN resman. CODE_TYPES where EXT_SYSTEM_ID=117 and ENTITY_ID=code_types
WHERE ext_system_id = 117
AND entity_id = 1); |