5
Good morning, you guys!
I’m trying to make an Oracle select using a SEQUENCE in id, but is giving error on account of a group by no select.
Dry up my SQL:
INSERT INTO SUP_T(ID, DESCRICAO)
SELECT SEQ_SUP_T.NEXTVAL,TIPO.TIPO
FROM TB_TIPO_APLICACAO TIPO
GROUP BY TIPO.TIPO;
The error that appears is as follows:
Relatório de erros -
Erro de SQL: ORA-02287: número de seqüência não permitido aqui
02287. 00000 - "sequence number not allowed here"
*Cause: The specified sequence number (CURRVAL or NEXTVAL) is inappropriate
here in the statement.
*Action: Remove the sequence number.
Someone’s been through it?
Thank you very much, Fernando!
– Victor Hugo