Hello everyone, I need a help here: when I've clicked in New Materialized View, and after being filled SQL Query tab with the follow query, I went to tab Indexes and then I clicked the green button to add new Index, a new window named "Index Expressions" saying "Calculating default column expressions for index" stay forever calculating something. After I click in Cancel button, a huge list of null values appears on Expressions list. Is it a bug?
SELECT -- LISTA EXAMES DE IMAGEM
ITPR.CD_ITPED_RX CD_ITEM_PEDIDO,
PR.CD_ATENDIMENTO,
A.CD_PACIENTE,
P.NM_PACIENTE,
P.NM_SOCIAL_PACIENTE,
'IMAGEM' TIPO_EXAME,
ER.DS_EXA_RX NM_EXAME,
PR.DT_PEDIDO,
ITPR.DT_ENTREGA, -- DT ENTREGA AO PACIENTE
ITPR.CD_EXA_RX CD_EXAME,
NVL(LRX.SN_EMITIDO, 'N') SN_EMITIDO,
ITPR.CD_PED_RX,
NULL CD_PED_LAB,
(
NVL(TRUNC(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO)/12),0) || 'A ' ||
NVL(TRUNC(MOD(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO),12)),0) || 'M ' ||
NVL(TRUNC(SYSDATE-ADD\_MONTHS(P.DT\_NASCIMENTO,TRUNC(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO)/12)\*12+TRUNC(MOD(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO),12)))),0) || 'D'
) IDADE,
ER.DS_ORIENTACAO
FROM
DBAMV.ITPED_RX ITPR
INNER JOIN DBAMV.PED_RX PR ON
PR.CD\_PED\_RX = ITPR.CD\_PED\_RX
INNER JOIN DBAMV.ATENDIME A ON
PR.CD\_ATENDIMENTO = A.CD\_ATENDIMENTO
INNER JOIN DBAMV.PACIENTE P ON
A.CD\_PACIENTE = P.CD\_PACIENTE
INNER JOIN DBAMV.EXA_RX ER ON
ITPR.CD\_EXA\_RX = ER.CD\_EXA\_RX
LEFT JOIN DBAMV.LAUDO_RX LRX ON
ITPR.CD\_LAUDO = LRX.CD\_LAUDO
UNION ALL
SELECT -- LISTA EXAMES LABORATORIO
ITPL.CD_ITPED_LAB CD_ITEM_PEDIDO,
PL.CD_ATENDIMENTO,
A.CD_PACIENTE,
P.NM_PACIENTE,
P.NM_SOCIAL_PACIENTE,
'LABORATORIO' TIPO_EXAME,
EL.NM_EXA_LAB NM_EXAME,
PL.DT_PEDIDO,
PL.DT_ENTREGA, -- DT ENTREGA AO PACIENTE
ITPL.CD_EXA_LAB CD_EXAME,
ITPL.SN_EMITIDO,
NULL CD_PED_RX,
PL.CD_PED_LAB,
(
NVL(TRUNC(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO)/12),0) || 'A ' ||
NVL(TRUNC(MOD(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO),12)),0) || 'M ' ||
NVL(TRUNC(SYSDATE-ADD\_MONTHS(P.DT\_NASCIMENTO,TRUNC(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO)/12)\*12+TRUNC(MOD(MONTHS\_BETWEEN(SYSDATE,P.DT\_NASCIMENTO),12)))),0) || 'D'
) IDADE,
EL.DS_ORIENTACAO
FROM
DBAMV.PED_LAB PL
INNER JOIN DBAMV.ITPED_LAB ITPL ON
ITPL.CD\_PED\_LAB = PL.CD\_PED\_LAB
INNER JOIN DBAMV.EXA\_LAB EL ON
ITPL.CD\_EXA\_LAB = EL.CD\_EXA\_LAB
INNER JOIN DBAMV.ATENDIME A ON
PL.CD\_ATENDIMENTO = A.CD\_ATENDIMENTO
INNER JOIN DBAMV.PACIENTE P ON
A.CD\_PACIENTE = P.CD\_PACIENTE
I am using SQL Developer Version 17.2.0.188 Build 188.1159.
Thank you since now!