#Mega #Tributos - Série/Subsérie - Gera INSERT pra incluir todas as numerações entre 1 e 999 para o cadastro de série do Tributos #MegaERP

MGTRF.TRF_SERIEDOCFIS_Incluir_em_Lote.sql

SELECT 
SEQ.RESULT SER_ST_CODIGO, 'INSERT INTO MGTRF.TRF_SERIEDOCFIS(ser_st_codigo, ser_st_descricao,ser_st_seriesintegra) '
|| 'SELECT '''||
    SEQ.RESULT
||''' SER_ST_CODIGO, ''Série '|| LPAD(SEQ.RESULT,3,'0') || ''' SER_ST_DESCRICAO, '''|| SEQ.RESULT ||''' SER_ST_SERIESINTEGRA ' 
|| 'FROM DUAL WHERE '''|| SEQ.RESULT ||''' NOT IN (SELECT T.SER_ST_CODIGO FROM MGTRF.TRF_SERIEDOCFIS T); COMMIT;'
"INS"
FROM MGTRF.TRF_SERIEDOCFIS A
RIGHT JOIN (
select result from
    (select rownum result from dual connect by level <= (
        999
        )) -- MAX
  where result >= (
    1
    ) -- MIN
) SEQ ON TO_CHAR(SEQ.RESULT) = A.SER_ST_CODIGO
WHERE A.SER_ST_CODIGO IS NULL
;