SELECT *
FROM
(
SELECT a.PROCDATE,a.SLOT,a.TYPE,a.PEC,a.PRIMARY,a.SECONDARY,a.OPC,a.HDT,
b.VALUE,b.KEY
FROM nvp_queryms a
LEFT JOIN nvp_querydmc b ON to_char(a.SLOT)= to_char(b.DMC)
WHERE a.HDT = '1010'
AND a.PROCDATE >= TO_DATE ('03/12/2019 00:00:00', 'dd/mm/yyyy HH24:MI:SS')
AND a.PROCDATE <= TO_DATE ('03/12/2019 23:59:59', 'dd/mm/yyyy HH24:MI:SS')
AND (b.MODEM IS Null OR b.MODEM = 'null')
AND (b.HDT IS Null OR b.HDT = '1010')
)
PIVOT