CODEWITHSUNDEEP
sqloracle-databaseoracle11g
user1251973
user1251973

Reputation: 331

ORA - 02287 sequence number not allowed here

I have a table name test which has three columns id, m_id and s_m_id

I am executing below query

select id,test.nextval listagg(m_id || ',' || s_m_id, ';') within group (order by m_id) as merge_ids 
from test t group by id

than I am getting error ORA - 02287 sequence number not allowed here.

Upvotes: 2

Views: 16681

Answers (1)

Codo
Codo

Reputation: 79033

You're trying to do too many things in one go. Create a subquery for the grouping and add the sequence numbers later:

select id, test.nextval, merge_ids
from (
    select id, listagg(m_id || ',' || s_m_id, ';') within group (order by m_id) as merge_ids
    from test t
    group by id
)

Upvotes: 5

Related Questions