ORA-01792: maximum number of columns in a table or view is 1000 Oracle 12c (12.1.0.2.0)
Hello,
I have query with multiple joins. When i run this query i qet error ORA-01792: maximum number of columns in a table or view is 1000
When i remove last join then query work good. Is it bug in oracle?
WIP_OPERATION is empty ....
(SELECT
1
FROM
WIP_OPERATION WOP where
rownum = 1) as x
SELECT
(SELECT
1
FROM
WIP_OPERATION WOP where
rownum = 1) as x
FROM
WIP_ORDER SRC
LEFT OUTER JOIN PRODUCT PP ON SRC.PRODUCTID= PP.ID
LEFT OUTER JOIN PROCESS PR ON SRC.PROCESSID=PR.ID
LEFT OUTER JOIN RECIPE RR ON SRC.RECIPEID = RR.ID
LEFT OUTER JOIN RESOURCE_ R ON SRC.RESOURCENAME = R.RESOURCENAME AND SRC.RESOURCETYPE = R.RESOURCETYPE