CODEWITHSUNDEEP
oracle-databaseplsqldblinklistaggora-00923
Nick
Nick

Reputation: 127

listagg DB link issue

For below query, I am only getting error:

ORA-00923: FROM keyword not found where expected when in DBLINK.

select LISTAGG(SERVICE_ORDER, ', ')  WITHIN GROUP (ORDER BY SERVICE_ORDER) 
"service_order"
FROM TBL_DATA@TBL_REP

Upvotes: 0

Views: 312

Answers (1)

kara
kara

Reputation: 3455

Works on 12c(12.1.0.2.0), too:

SELECT LISTAGG (SERVICE_ORDER, ', ') WITHIN GROUP (ORDER BY SERVICE_ORDER)
           "service_order"
  FROM (SELECT 'a' SERVICE_ORDER FROM DUAL
        UNION ALL
        SELECT 'b' SERVICE_ORDER FROM DUAL
        UNION ALL
        SELECT 'c' SERVICE_ORDER FROM DUAL)

Upvotes: 0

Related Questions