SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT WHERE BALCO_PAT IS NULL 
SELECT * FROM PT_CADPAT WHERE DATAE_PAT BETWEEN '01.01.2013' AND '31.12.2013' 
SELECT * FROM PT_CADPAT WHERE ORIG_PAT ='O' AND DATAE_PAT BETWEEN '01.01.2013' AND '31.12.2013' 
SELECT * FROM PT_CADPAT WHERE ORIG_PAT ='GO' 
SELECT * FROM PT_CADPAT WHERE ORIG_PAT ='O' 
SELECT * FROM PT_CADPAT WHERE ORIG_PAT ='I' 
SELECT * FROM PT_CADPAT WHERE ORIG_PAT ='O' 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT BETWEEN '3176' AND '3191' 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT BETWEEN '003176' AND '003191' 
UPDATE PT_CADPAT SET PROPRI_PAT ='PREFEITURA MUNICIPAL DE FIGUEIROPOLIS',OBS_PAT='INCORPORACAO'  WHERE CHAPA_PAT BETWEEN '003176' AND '003191' 
UPDATE PT_CADPAT SET PROPRI_PAT ='PREFEITURA MUNICIPAL DE FIGUEIROPOLIS',OBS_PAT='INCORPORACAO'  WHERE CHAPA_PAT BETWEEN '003851' AND '003854' 
UPDATE PT_CADPAT SET PROPRI_PAT ='PREFEITURA MUNICIPAL DE FIGUEIROPOLIS',OBS_PAT='INCORPORACAO'  WHERE CHAPA_PAT IN ('001779', '003221','003449') 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT BETWEEN '003176' AND '003191' 
UPDATE PT_CADPAT SET PROPRI_PAT ='PREFEITURA MUNICIPAL DE FIGUEIROPOLIS',OBS_PAT='INCORPORACAO'  WHERE CODIGO_PAT ='1772' 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT BETWEEN '003176' AND '003191' 
SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT BETWEEN '8' AND '9' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' AND BALCO_PAT NOT LIKE '3311%' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' AND BALCO_PAT NOT LIKE '331%' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' AND BALCO_PAT NOT LIKE '331101%' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' AND BALCO_PAT NOT LIKE '33110%' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' AND BALCO_PAT NOT LIKE '3312%' 
SELECT * FROM PT_CADPAT WHERE CODIGO_TIP_PAT <> '8' AND CODIGO_TIP_PAT <> '9' 
SELECT * FROM CADPED 
SELECT * FROM DESPES 
SELECT * FROM CADPED C, DESPES D WHERE D.FICHA ='16' 
SELECT * FROM CADPED C WHERE C.FICHA ='16' 
SELECT * FROM CADPED C, DESPES D WHERE C.FICHA ='16' AND C.NUMPED NOT IN (SELECT NUMPED FROM DESPES) 
SELECT * FROM CADPED C, DESPES D WHERE C.FICHA ='16' AND C.NUMPED NOT IN (SELECT D.NUMPED FROM DESPES) 
SELECT * FROM CADPED C, DESPES D WHERE C.FICHA=D.FICHA AND C.NUMPED NOT IN (SELECT D.NUMPED FROM DESPES) 
SELECT * FROM CADPED C, DESPES D WHERE C.FICHA=D.FICHA 
SELECT * FROM CADPED C, DESPES D WHERE C.FICHA=D.FICHA AND C.NUMPED <> D.NUMPED 
SELECT * FROM CADPED C, DESPES D WHERE C.FICHA=D.FICHA AND C.NUMPED <> D.NUMPED AND C.FICHA = '16' 
SELECT * FROM CADPED C, DESPES D WHERE C.NUMPED <> D.NUMPED AND C.FICHA = '16' 
SELECT * FROM DESPES WHERE FICHA = 16 
SELECT NUMPED FROM DESPES WHERE FICHA = 16 
SELECT * FROM ICADPED 
SELECT * FROM ICADPED WHERE FICHA = 16 
SELECT * FROM ICADPED I, DESPES D WHERE I.FICHA = 16 
SELECT * FROM ICADPED I, DESPES D WHERE I.FICHA = D.FICHA AND I.FICHA = 16 
SELECT * FROM ICADPED I, DESPES D WHERE I.FICHA = 16  AND I.NUMPED <> D.NUMPED 
SELECT * FROM ICADPED I, DESPES D WHERE  I.NUMPED <> D.NUMPED AND I.FICHA = 16 
SELECT * FROM ICADPED I, DESPES D WHERE  I.NUMPED <> D.NUMPED AND I.FICHA=D.FICHA AND I.FICHA =16 
SELECT * FROM CADPED WHERE FICHA = 16 
SELECT * FROM CADPED WHERE FICHA = 16 AND NUM IN ('85','97','99','318') 
SELECT * FROM CADPED WHERE FICHA = 16 AND NUM IN ('0085','97','99','318') 
SELECT * FROM CADPED WHERE FICHA = 16 AND NUM IN ('0085','0097','0099','00318') 
SELECT * FROM CADPED WHERE FICHA = 16 AND NUM IN ('00085','0097','00099','00318') 
SELECT * FROM CADPED WHERE FICHA = 16 AND NUM IN ('00085','00097','00099','00318') 
SELECT * FROM ICADPED 
SELECT * FROM ICADPED WHERE NUMPED IN ('00085/14','00097/14','00099/14','00318/14') 
SELECT * FROM CADLIC 
SELECT * FROM CADLIC WHERE NUMPRO = 3 
SELECT * FROM CADLIC WHERE NUMPRO = 3 AND PROCLIC = '000003/14' 
UPDATE CADLIC SET REGISTROPRECO ='S' WHERE NUMPRO = 3 AND PROCLIC = '000003/14' 
SELECT * FROM CADLIC WHERE NUMPRO = 3 AND PROCLIC = '000003/14' 
SELECT * FROM CADPROLIC 
SELECT * FROM REGPRECO 
SELECT * FROM CADLIC WHERE NUMPRO = 3 AND PROCLIC = '000003/14' 
SELECT * FROM REGPRECO 
SELECT * FROM CADLIC WHERE NUMPRO = 3 AND PROCLIC = '000003/14' 
SELECT * FROM REGPRECO 
SELECT * FROM DESPES WHERE NEMPG = 2082 
SELECT * FROM DESPES WHERE NEMPG = 2082 AND TPEM ='ES' 
SELECT * FROM CADPED WHERE NUM = 00123 
SELECT NUMLIC FROM CADLIC WHERE PROCLIC ='000008/14' 
SELECT * FROM CADPED WHERE NUM = 00123 
SELECT NUMLIC FROM CADLIC WHERE PROCLIC ='000010/14' 
SELECT * FROM CADPED WHERE NUM = 00124 
SELECT NUMLIC FROM CADLIC WHERE PROCLIC ='000010/14' 
SELECT * FROM CADPED WHERE NUM = 00124 
SELECT NUMLIC FROM CADLIC WHERE PROCLIC ='000010/14' 
SELECT * FROM CADPED WHERE NUM = 00124 
SELECT * FROM ICADPED 
SELECT * FROM ICADPED WHERE PRCUNT > PRCTOT 
SELECT * FROM ICADPED WHERE PRCUNT >= PRCTOT 
SELECT * FROM CONDIA 
SELECT * FROM CONDIA_TCE 
SELECT * FROM DESALD 
SELECT * FROM DESALD WHERE DECRETO = 7 
UPDATE DESALD SET TIPO_RECURSO ='1-Anulação de dotação' WHERE TIPO_RECURSO ='3-Operação de Crédito' AND DECRETO = 7 
SELECT * FROM DESALD WHERE DECRETO = 7 
SELECT * FROM DESALD WHERE DECRETO = 7 AND FICHA IN ('130','131','138','176') 
SELECT * FROM DESALD WHERE FICHA IN ('130','131','138','176') 
SELECT * FROM DESALD WHERE DECRETO = 7 AND FICHA IN ('130','131','138','176') 
SELECT * FROM CONTRATOSACOMPANHAMENTO 
SELECT * FROM DESALD WHERE FICHA IN ('130','131','138','176') 
SELECT * FROM DESALD 
SELECT * FROM REQUI 
SELECT * FROM REQUI WHERE CODCCUSTO IN ('107','162') 
SELECT * FROM PORTARIA 
SELECT * FROM PORTARIA WHERE PLACA IN ('BTB7542') 
SELECT * FROM PORTARIA WHERE PLACA IN ('BTB6542') 
SELECT * FROM ICADORC_FIC 
SELECT * FROM ICADORC_FIC WHERE NUMORC = '00924/14' 
SELECT * FROM ICADORC_FIC WHERE NUMORC = '00929/14' 
DELETE FROM ICADORC_FIC WHERE CODIGO > 1 AND NUMORC = '00929/14' 
SELECT * FROM ICADORC_FIC WHERE NUMORC = '00929/14' 
SELECT * FROM ICADORC_FIC WHERE NUMORC = '00433/13' 
SELECT * FROM CADPED 
SELECT * FROM CADPED   WHERE INTERE ='AMARILDO PEDRO DO NASCIMENTO' 
SELECT * FROM CADLIC 
SELECT * FROM CADLIC WHERE LICIT ='dispensa' 
SELECT * FROM TRABALHADOR 
SELECT * FROM CADPED 
SELECT * FROM CADLIC 
SELECT * FROM CADLICITACAO 
SELECT * FROM CADLIC 
SELECT * FROM CADLICITACAO 
SELECT * FROM CADLIC 
DELETE FROM CONFIG_SCPI WHERE PARAMETRO = 'VERRECDIAR' 
select * from config_scpi 
SELECT * FROM DESPES WHERE NEMPG = 2082 
SELECT * FROM cadest 
SELECT * FROM cadLIC 
SELECT * FROM cadest 
SELECT * FROM dessub 
SELECT * FROM CADPED WHERE NUM = 00123 
SELECT * FROM CADLIC 
SELECT * FROM DESPES WHERE NEMPG=325 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT PKEMP FROM DESPES WHERE NEMPG=325 
SELECT * FROM DESPES WHERE NEMPG=325 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM DESPES WHERE NEMPG=325 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESPES WHERE NEMPG=325 
SELECT * FROM SUBORD WHERE PKEMP=934 
SELECT * FROM DESSUB WHERE PKEMP=934 
SELECT * FROM VIEWLIQ WHERE PKEMP=934 
SELECT * FROM DESPES WHERE NEMPG=325 
SELECT * FROM DESPES WHERE NEMPG=1307 
SELECT * FROM SUBORD WHERE PKEMP=3350 
SELECT * FROM DESSUB WHERE PKEMP=3350 
SELECT * FROM VIEWLIQ WHERE PKEMP=3350 
SELECT PKEMP FROM DESPES WHERE NEMPG=1307 
SELECT * FROM DESPES WHERE NEMPG=1307 
SELECT * FROM VIEWLIQ WHERE PKEMP=3350 
SELECT * FROM DESSUB WHERE PKEMP=3350 
SELECT * FROM SUBORD WHERE PKEMP=3350 
SELECT PKEMP FROM DESPES WHERE NEMPG=1307 
SELECT * FROM DESPES WHERE NEMPG=1307 
UPDATE DESPES SET SUBEMPENHADO='0' WHERE PKEMP=3350 
SELECT * FROM DESPES WHERE NEMPG=1307 
SELECT * FROM SUBORD WHERE PKEMP=3350 
SELECT * FROM SUBORD WHERE PKEMP=1620 
SELECT * FROM DESPES WHERE NEMPG=1307 
SELECT * FROM DESPES WHERE NEMPG=325 
SELECT * FROM ORDPAG 
SELECT * FROM DESPES WHERE NEMPG=604 
SELECT PKEMP FROM DESPES WHERE NEMPG=604 
SELECT * FROM SUBORD WHERE PKEMP=962 
SELECT * FROM DESPES WHERE NEMPG=962 
SELECT * FROM VIEWLIQ WHERE PKEMP=962 
SELECT * FROM DESSUB WHERE PKEMP=962 
SELECT * FROM VIEWLIQ WHERE PKEMP=962 
SELECT PKEMP FROM DESPES WHERE NEMPG=604 
SELECT * FROM DESPES WHERE NEMPG=604 
SELECT * FROM VIEWLIQ WHERE PKEMP=962 
SELECT * FROM DESSUB WHERE PKEMP=962 
SELECT * FROM DESPES WHERE NEMPG=604 
SELECT * FROM DESPES WHERE NEMPG=605 
SELECT * FROM SUBORD WHERE PKEMP=963 
SELECT * FROM DESSUB WHERE PKEMP=963 
SELECT * FROM VIEWLIQ WHERE PKEMP=962 
SELECT * FROM DESSUB WHERE PKEMP=963 
SELECT * FROM DESPES WHERE NEMPG=605 
SELECT * FROM DESSUB WHERE PKEMP=965 
SELECT PKEMP FROM DESPES WHERE NEMPG=605 
SELECT * FROM DESSUB WHERE PKEMP=963 
SELECT * FROM VIEWLIQ WHERE PKEMP=963 
SELECT PKEMP FROM DESPES WHERE NEMPG=605 
SELECT * FROM DESPES WHERE NEMPG=605 
SELECT * FROM DESPES WHERE NEMPG=604 
SELECT * FROM DESPES WHERE NEMPG=4539 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM DESPES WHERE NEMPG=4539 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESPES WHERE NEMPG=4539 
SELECT * FROM SUBORD WHERE PKEMP=4539 
SELECT * FROM SUBORD WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM SUBORD WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM SUBORD WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM SUBORD WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM SUBORD WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESPES WHERE NEMPG=4539 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
SELECT * FROM DESSUB WHERE PKEMP=6936 
SELECT * FROM VIEWLIQ WHERE PKEMP=6936 
UPDATE CADCLI SET TRAVA = NULL , TRAVADIARIO =NULL 
update TabProjAtiv set DT_INSERIR = '01.11.2015' where PROJATIV = '1190' 
SELECT * FROM FONRO 
SELECT * FROM PPA_ACOES 
SELECT * FROM PPA_ACAOALT 
SELECT * FROM PPA_ACOES 
SELECT * FROM PPA_ACAOALT 
SELECT * FROM PPA_ACOES 
SELECT * FROM PPA_ACAOALT 
SELECT * FROM PPA_ACOES 
SELECT * FROM PPA_ACAOALT 
SELECT * FROM PPA_ACOES 
SELECT * FROM PPA_ACAOALT 
SELECT * FROM PPA_ACOES 
SELECT * FROM PPA_ACAOALT 
SELECT * FROM PPA_ACOES 
update cadcli set trava= null, travadiario = null 
SELECT * FROM ICADORC WHERE NUMORC = '00124/15' 
update cadcli set trava= null, travadiario = null 
SELECT * FROM CADORC 
SELECT * FROM CADORC WHERE NUMORC = '00124/15' 
SELECT * FROM  ICADORC WHERE NUMORC = '00124/15' 
SELECT * FROM RECORC 
SELECT * FROM DESORC 
SELECT * FROM RECORC 
SELECT * FROM DESORC 
SELECT cfpro,catec,FONINDUSO,fongrupo,foncodigo,FONRO, Count(*) FROM desdis group BY cfpro,catec,FONINDUSO,fongrupo,foncodigo,FONRO 
SELECT * FROM desdis 
SELECT * FROM desdis WHERE FICHA ='670' 
SELECT * FROM desdis 
SELECT * FROM desorc 
select * from cadped 
select * from icadped 
update parampatri set correlacao_pcasp_ok = null 
select * from condia_tce where balco like '2188%' 
select * from condia_tce where balco like '21881010100%' 
select * from dessub_retencao 
select * from  receit 
select * from dessub_retencao r inner join receit t on r.receit =t.nlanc 
select * from dessub_retencao r inner join receit t on r.receit =t.nlanc where t.ficha = 9051 
select * from dessub_retencao 
select * from dessub_retencao r inner join receit t on r.receit =t.nlanc where t.ficha = 9051 
select * from  receit 
select * from dessub_retencao r inner join receit t on r.receit =t.nlanc where t.ficha = 9051 
select * from dessub_retencao r LEFT join receit t on r.receit =t.nlanc where t.ficha = 9051 
select * from dessub_retencao r LEFT join receit t on r.receit =t.ORDCRE where t.ficha = 9051 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%132/1/OR%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%54/1/OR%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%054/1/OR%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%54/1/OR%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%54/1/%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%54/' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%54/%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%54%' 
select * from dessub_retencao d inner join RECEIT R ON D.RECEIT =R.ORDCRE WHERE R.HISTO LIKE '%206/1/OR%' 
select * from dessub_retencao WHERE CODRETPAGO IN (104,207,223,228,238,257,242,243,265,261) 
SELECT * FROM RECORC 
SELECT * FROM desORC 
select * from icadped 
SELECT * FROM CADLIC 
SELECT NEMPG, TPEM, VINGRUPO, VINCODIGO FROM DESPES WHERE VINGRUPO = 110 AND VINCODIGO = 00 AND TPEM = 'EX' 
UPDATE DESPES SET VINGRUPO = '001', VINCODIGO='001'  WHERE VINGRUPO = '110' AND VINCODIGO = '000' AND TPEM = 'EX' 
update cadcli set trava= null, travadiario = null 
SELECT * FROM DESPES 
UPDATE DESPES SET CODIF = '30' WHERE CODIF = '31' AND TPEM = 'OR' 
SELECT * FROM DESPES 
SELECT NEMPG, TPEM, VINGRUPO, VINCODIGO FROM DESPES WHERE VINGRUPO = 110 AND VINCODIGO = 000 AND TPEM = 'OR' 
SELECT NEMPG, TPEM, VINGRUPO, VINCODIGO FROM DESPES WHERE VINGRUPO = 110 AND VINCODIGO = 000 AND TPEM = 'OR'  AND CODIF = '30' 
SELECT NEMPG, TPEM, VINGRUPO, VINCODIGO FROM DESPES WHERE NEMPG IN ('16','39','88','122','158') AND VINGRUPO = 110 AND VINCODIGO = 000 AND TPEM = 'OR'  AND CODIF = '30' 
UPDATE DESPES SET CODIF ='31' WHERE NEMPG IN ('16','39','88','122','158') AND VINGRUPO = 110 AND VINCODIGO = 000 AND TPEM = 'OR'  AND CODIF = '30' 
select * from dessub_retencao 
select * from DESPES 
select * from condia_tce where balco like '8123%' 
select * from dessub_retencao 
select * from DESPES 
select * from cadpatd 
select * from cadpat 
select * from pt_cadpatd 
select * from pt_manutencao 
select * from pt_inventario 
select * from pt_inventario_bem 
select * from pt_comissao_reav 
select * from pt_cadtip 
select * from PT_MOVBEM 
select * from PT_cadpat 
select * from PT_cadajuste 
select * from PT_MOVBEM 
select data_mov, '01/01/2016' from PT_MOVBEM 
select * from PT_MOVBEM 
select dt_contabil, '01/01/2016' from PT_MOVBEM 
select dt_contabil, '01/02/2016' from PT_MOVBEM 
select * from PT_MOVBEM 
select codigo_mov, '6758' from PT_MOVBEM 
select * from PT_MOVBEM 
select * from PT_cadpat 
select * from PT_MOVBEM 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '01.12.2015' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2016' AND '01.12.2016' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '23711030000' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_CADPAT 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NOT NULL 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT  IS NULL 
select * from PT_MOVBEM 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '12311030300' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '23711030000' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
select * from PT_CADPAT 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '12311050100'  WHERE CODIGO_CPL_MOV= '23711030000' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV='12311050100' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A,R' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A,R,B' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'R' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A,B' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '12311030300' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '12311030300'  WHERE CODIGO_CPL_MOV= '23711030000' 
select * from PT_MOVBEM 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV= '23711030000' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE TIPO_MOV='A' 
select * from PT_MOVBEM 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV='12311050100' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
UPDATE  PT_MOVBEM SET CODIGO_CPL_MOV='23711030000' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015'  AND TIPO_MOV <> 'A' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV <> 'A' 
select * from PT_CADPAT 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NULL 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NOT NULL 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NOT NULL  AND CODIGO_CPL_PAT LIKE '1231%' 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NULL  AND CODIGO_CPL_PAT LIKE '1231%' 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NULL  AND CODIGO_CPL_PAT LIKE '1231%' AND DATAE_PAT BETWEEN '01.01.2015' AND '31.12.2015' 
SELECT * FROM PT_MOVBEM 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' 
select * from PT_CADPAT WHERE CODIGO_BAI_PAT IS NULL  AND CODIGO_CPL_PAT LIKE '1231%' AND DATAE_PAT BETWEEN '01.01.2015' AND '31.12.2015' 
UPDATE PT_MOVBEM SET CODIGO_CPL_MOV ='12311030300' WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' 
SELECT MAX (CODIGO_MOV) FROM PT_MOVBEM 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7119', EMPRESA_MOV,CODIGO_PAT_MOV,'R', CODIGO_CPL_MOV FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' 
SELECT * FROM PT_MOVBEM WHERE CODIGO_MOV > 7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7120', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7122', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7123', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7124', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7125', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7126', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7127', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
INSERT INTO PT_MOVBEM (CODIGO_MOV, EMPRESA_MOV,CODIGO_PAT_MOV,TIPO_MOV, CODIGO_CPL_MOV) SELECT '7128', EMPRESA_MOV,CODIGO_PAT_MOV,'R', 23711030000 FROM PT_MOVBEM  WHERE CODIGO_MOV=7118 
SELECT * FROM PT_MOVBEM WHERE CODIGO_MOV > 7118 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' OR CODIGO_MOV > 7118 
UPDATE PT_MOVBEM SET CODIGO_CPL_MOV = '23711030000' WHERE CODIGO_MOV =7119 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' OR CODIGO_MOV > 7118 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5928) WHERE M.CODIGO_MOV=7120 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' OR CODIGO_MOV > 7118 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5929) WHERE M.CODIGO_MOV=7122 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5923) WHERE M.CODIGO_MOV=7123 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5930) WHERE M.CODIGO_MOV=7123 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5931) WHERE M.CODIGO_MOV=7124 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5932) WHERE M.CODIGO_MOV=7125 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5933) WHERE M.CODIGO_MOV=7126 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5934) WHERE M.CODIGO_MOV=7127 
UPDATE PT_MOVBEM M SET M.CODIGO_PAT_MOV = (SELECT C.CODIGO_PAT_MOV FROM PT_MOVBEM C WHERE C.CODIGO_MOV =5935) WHERE M.CODIGO_MOV=7128 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' OR CODIGO_MOV > 7118 
UPDATE PT_MOVBEM SET  DATA_MOV = '31.12.2015' WHERE CODIGO_MOV > 7118 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' OR CODIGO_MOV > 7118 
SELECT TRAVA, TRAVADIARIO FROM CADCLI 
UPDATE CADCLI SET TRAVA = NULL 
UPDATE PT_MOVBEM SET  DT_CONTABIL=DATA_MOV  WHERE CODIGO_MOV > 7118 
UPDATE PT_MOVBEM SET  DATA_MOV = '31.12.2015' WHERE CODIGO_MOV > 7118 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' AND TIPO_MOV ='A' OR CODIGO_MOV > 7118 
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV = 62 
select * from PT_MOVBEM 
select * from PT_MOVBEM WHERE DATA_MOV BETWEEN '01.01.2015' AND '31.12.2015' 
UPDATE CADCLI SET TRAVA = NULL , TRAVADIARIO =NULL 
SELECT * FROM DESSUB_RETENCAO 
UPDATE CADCLI SET TRAVA = NULL , TRAVADIARIO =NULL 
SELECT * FROM PPAACOES 
SELECT * FROM PPA_PROGRAMA 
SELECT * FROM PPA_METAS 
SELECT * FROM PPACAD 
UPDATE CADCLI SET TRAVA = NULL 
UPDATE REGPRECODOC SET CODATUALIZACAO =2 WHERE NUMLIC=3 AND CODATUALIZACAO = 1; 
SELECT A.* FROM   DOCUMENTOS_RTF A   INNER JOIN CADLIC B ON B.NUMLIC = A.NUMLIC   INNER JOIN DESFOR C ON C.CODIF = A.NUMERO   LEFT JOIN CENTROCUSTO D ON D.CODCCUSTO = B.CODCCUSTO   LEFT JOIN CADLICITACAO E ON E.NUMLIC = B.NUMLIC WHERE   B.DTENVIO_TCE = '08.07.2016'   AND A.TIPO IN (6,7) 
select count (*), balco from condia_tce where balco in ('62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '52291010000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291010000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000', '62291020000') group by balco 
SELECT * FROM CADLIC 
UPDATE CADCLI SET TRAVA = NULL , TRAVADIARIO =NULL 
SELECT * FROM ICADORC_COT 
SELECT * FROM CADORC_FIC 
SELECT * FROM ICADORC_cot 
SELECT * FROM ICADORC_cot where numorc ='00002/16' 
SELECT * FROM CENTROCUSTO 
UPDATE CENTROCUSTO SET DESTINO= '000000202' WHERE CODCCUSTO = 91 
SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT  WHERE VALATU_PAT ='78' 
SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT  WHERE VALATU_PAT ='78.00' 
SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE '%0%' AND VALAQU_PAT IS NULL 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE '%VALAQU_RAT%' AND VALAQU_PAT IS NULL 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT  IS NULL 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE'0' 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE'0%' 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE'78,00%' 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE'78%' 
SELECT * FROM PT_CADPAT WHERE VALAQU_PAT LIKE'0%' 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT=11 
select * from desfor 
select * from desfor where insmf = '034.118.791-73' 
select * from desfor 
select * from desfor where nome = 'RIKELLY CRISTINA DE SOUZA CABRAL' 
select * from desfor 
select * from desfor where nome = 'RIKELLY CRISTINA DE SOUZA CABRAL' 
select * from desfor where nome= 'RIKELLY' 
SELECT * FROM DESFOR WHERE NOME LIKE 'RIKELLY%' 
SELECT * FROM desorc 
SELECT * FROM desorc  where cfpro  like'15.451.%' 
SELECT * FROM desorc  where cfpro  like'15.451.1013.1071.0000%' 
SELECT * FROM desdis  where cfpro  like'15.451.1013.1071.0000%' 
select * from ppaacoes 
select * from ppa_acoes 
delete from condia_tce where ie is null 
update condia_tce set seq_sagres = null where ie <> '2' 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191924 where ie in ('0','1') 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191925 where ie in ('0','1') 
SELECT max(seq_sagres) from condia_tce 
delete from condia_tce where ie is null 
SELECT max(seq_sagres) from condia_tce 
delete from condia_tce where ie is null 
update condia_tce set seq_sagres = null where ie <> '2' 
update condia_tce set seq_sagres = null where ie <> '1' 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 9835 where ie in ('0','1') 
SELECT max(seq_sagres) from condia_tce 
SET GENERATOR GEN_CONPLA_SAGRES_ID TO 9835 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191925 where ie in ('0','1') 
SELECT max(seq_sagres) from condia_tce 
delete from condia_tce where ie is null 
SELECT max(seq_sagres) from condia_tce 
update condia_tce set seq_sagres = null where ie <> '2' 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191925 where ie in ('0','1') 
delete from condia_tce where ie is null 
update condia_tce set seq_sagres = null where ie <> '2' 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191925 where ie in ('0','1') 
SET GENERATOR GEN_CONPLA_SAGRES_ID TO 191925 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191926 where ie in ('0','1') 
SELECT * FROM CONDIA_TCE 
SELECT * FROM LEGIS_AUDESP 
SELECT * FROM TCEMT_LEI 
SELECT * FROM CAD_LEISDIVERSAS 
SELECT * FROM TCEMT_LEI 
SELECT P.LEI FROM PARAMORC P 
SELECT EXTRACT(YEAR FROM P.DTLEI) FROM PARAMORC P 
SELECT   C.EMPRESA,   B.NEMPG as SOLIC_NUMPROCESSO,   EXTRACT(YEAR FROM B.DATAE) AS ANOEMP,   A.MATRICULA AS PESS_MATRICULA,   CASE     WHEN A.TIPO = 'M' THEN '1'     ELSE '2'   END AS ADTO_TIPO,   B.DATAE AS ADTO_DATA,   B.VADEM AS ADTO_VALOR,   CAST(SUBSTRING(B.PRODU FROM 1 FOR 120) AS VARCHAR(120)) AS ADTO_OBJETIVO,   (SELECT P.LEI FROM PARAMORC P) AS LEI_NUMERO,   (SELECT EXTRACT(YEAR FROM P.DTLEI) FROM PARAMORC P) AS ANOLEI,   D.DECRETO AS DECRETO,   C.ORGAO AS ORG_CODIGO,   C.UNIDADE AS UNOR_CODIGO,   B.NEMPG AS EMP_NUMERO FROM   DESPESAD A   INNER JOIN DESPES B ON B.PKEMP = A.PKEMP   INNER JOIN DESDIS C ON C.FICHA = B.FICHA   LEFT JOIN DESALD D ON D.FICHA = C.FICHA AND EXTRACT(MONTH FROM D.DTLAN) = '11' AND EXTRACT(YEAR FROM D.DTLAN) = (SELECT CADCLI.MEXER FROM CADCLI) WHERE   EXTRACT(MONTH FROM B.DATAE) = '03'   AND EXTRACT(YEAR FROM B.DATAE) = (SELECT CADCLI.MEXER FROM CADCLI)   AND B.TPEM = 'AD' 
SELECT EXTRACT(YEAR FROM P.DTLEI) FROM PARAMORC P 
SELECT   C.EMPRESA,   B.NEMPG as SOLIC_NUMPROCESSO,   EXTRACT(YEAR FROM B.DATAE) AS ANOEMP,   A.MATRICULA AS PESS_MATRICULA,   CASE     WHEN A.TIPO = 'M' THEN '1'     ELSE '2'   END AS ADTO_TIPO,   B.DATAE AS ADTO_DATA,   B.VADEM AS ADTO_VALOR,   CAST(SUBSTRING(B.PRODU FROM 1 FOR 120) AS VARCHAR(120)) AS ADTO_OBJETIVO,   (SELECT P.LEI FROM PARAMORC P) AS LEI_NUMERO,   (SELECT EXTRACT(YEAR FROM P.DTLEI) FROM PARAMORC P) AS ANOLEI,   D.DECRETO AS DECRETO,   C.ORGAO AS ORG_CODIGO,   C.UNIDADE AS UNOR_CODIGO,   B.NEMPG AS EMP_NUMERO FROM   DESPESAD A   INNER JOIN DESPES B ON B.PKEMP = A.PKEMP   INNER JOIN DESDIS C ON C.FICHA = B.FICHA   LEFT JOIN DESALD D ON D.FICHA = C.FICHA AND EXTRACT(MONTH FROM D.DTLAN) = '11' AND EXTRACT(YEAR FROM D.DTLAN) = (SELECT CADCLI.MEXER FROM CADCLI) WHERE   EXTRACT(MONTH FROM B.DATAE) = '03'   AND EXTRACT(YEAR FROM B.DATAE) = (SELECT CADCLI.MEXER FROM CADCLI)   AND B.TPEM = 'AD' 
SELECT * FROM DESPES 
SELECT * FROM CADLIC 
SELECT max(seq_sagres) from condia_tce 
UPDATE CONDIA_TCE SET SEQ_SAGRES = 191926 where ie in ('0','1') 
SELECT * FROM NOTA 
UPDATE OR INSERT INTO FONGRUPO (FONGRUPO, FONGRUPODESC) VALUES ('1','Recursos do Exercício Corrente'); UPDATE OR INSERT INTO FONGRUPO (FONGRUPO, FONGRUPODESC) VALUES ('3','Recursos de Exercícios Anteriores'); UPDATE OR INSERT INTO FONGRUPO (FONGRUPO, FONGRUPODESC) VALUES ('9','Recursos Condicionados'); DELETE FROM FONGRUPO WHERE FONGRUPO NOT IN ('1','3','9'); 
SELECT * FROM NOTA 
select * from condia_tce where ie is null 
SELECT FIRST 1 * FROM TCE_LANC_CONTABIL 
SELECT * FROM TCE_LANC_CONTABIL 
select * from condia_tce 
select * from condia_tce WHERE SEQUENCIA IS NULL 
select * from condia_tce 
select * from condia_tce WHERE SEQ IS NULL 
select * from condia_tce 
select * from condia_tce WHERE SEQUENCIA ='184170' 
select * from condia_tce WHERE SEQUENCIA ='0' 
select * from condia_tce 
select * from condia_tce WHERE SEQ_SAGRES='0' 
select * from condia_tce 
SELECT max(seq_sagres) from condia_tce 
select * from despes 
select * from despes where pkemp ='1' 
select * from despes 
select * from despes where codif ='1127' 
update parampatri set correlacao_pcasp_ok = null 
select * from CENTROCUSTO 
select * from CHEQORD 
select * from CHEQORD WHERE DTLAN='18.10.2016' 
select * from CHEQORD 
select * from CHEQORD WHERE DTLAN='18.10.2016' 
select * from CHEQORD WHERE DTLAN='19.10.2016' 
select * from CHEQORD WHERE DTLAN='18.10.2016' 
select * from CHEQORD WHERE DTLAN='19.10.2016' 
select * from DESCEMP 
select * from DESCSUB 
select * from DESSUB 
select * from DESSUB WHERE VENCI='19.10.2016' 
select * from DESSUB 
select * from DESSUB  WHERE NUMSUB='2496' 
select * from DESSUB  WHERE NUMSUB=2496 
select * from DESSUB  WHERE NUMSUB= 2496 
select * from dessub where pkemp ='205' and numsub in (5,50) 
SELECT * FROM TCEMT_LEI 
SELECT * FROM VEICULO 
SELECT * FROM VEICULO  where chassi='9532E82W9DR334003' 
SELECT * FROM VEICULO  where chassi='9532E82WODR31370' 
SELECT * FROM VEICULO 
SELECT * FROM VEICULO  where chassi='9C2JA2109R020085' 
SELECT * FROM VEICULO 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9C2JA2109R020085' 
SELECT * FROM VEICULO 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9BD15822AD6845461' 
SELECT * FROM VEICULO 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9BFYCEHV6ABB43492' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532E82WODR315839' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532E82W0DR315839' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532E82WODR315839' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532EB2W9DR334033' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532E82WODR315839' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9536E7235ER447630' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9BD171744ZG7585718' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532EB2W9DR334033' 
SELECT * FROM VEICULO WHERE IDENTIFIC_TCE ='9532E82WODR31370' 
SELECT * FROM VEICULO 
SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='0051303' 
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='051303' 
SELECT * FROM CADLIC 
SELECT * FROM TCEMT_LEI 
SELECT * FROM CADLIC 
SELECT * FROM DOCUMENTOS_RTF 
SELECT  * FROM PR_ESTORNODOCUMENTOFISCALLIQUID 
SELECT * FROM TCEMT_DOCDIVERSOS 
select * from   descon 
select * from   descon_detalhe 
select * from   descon 
SELECT * FROM CADLIC 
SELECT * FROM VEICULO 
SELECT * FROM DESPES 
SELECT  * FROM DESPESITEM 
SELECT  * FROM DESPES 
SELECT  * FROM DESPES where nempg ='20' 
SELECT * FROM DESPES 
SELECT * FROM DESPES WHERE NEMPG IN (20,21,22,23,24,25,26,27) 
SELECT * FROM DESPES WHERE NEMPG IN (161,162,163,164,165,167) 
SELECT * FROM DESPES WHERE NEMPG IN (161,162,163,164,165,166,167) 
DELETE FROM DESPES WHERE NEMPG IN (161,162,163,164,165,166,167) 
SELECT * FROM DESPES 
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL 
SELECT *  from TCEPE_CPP 
DELETE  from TCEPE_CPP 
SELECT *  from TCEPE_CPP 
delete  from TCEPE_CPP 
CREATE TABLE TCEPE_CPP( TPREGIME INTEGER NOT NULL, DESCREGIME V50 NOT NULL, TPFOLHA INTEGER NOT NULL, DESCFOLHA V50 NOT NULL, VLBASECALC VAL /* VAL = DOUBLE PRECISION default 0 */, VLREMUN VAL /* VAL = DOUBLE PRECISION default 0 */, VLDEVIDO VAL /* VAL = DOUBLE PRECISION default 0 */, VLCONTAB VAL /* VAL = DOUBLE PRECISION default 0 */, VLBENEFICIO VAL /* VAL = DOUBLE PRECISION default 0 */, VLRECOLHIDO VAL /* VAL = DOUBLE PRECISION default 0 */ ); 
SELECT *  from TCEPE_CPP 
select * from viewliq 
update viewliq  set  dtatesto= datae 
select * from viewliq 
update viewliq  set  codif_respatesto=560 
select * from desfor 
select * from cadped 
update cadest set codbarra=cadprotce; 
SELECT * FROM DESPES 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM DESPES 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM DESPES  WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM viewliq 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
DELETE FROM DESSUB WHERE PKEMP='761' AND NUMSUB='1' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE VENCI='31.12.2017' 
SELECT * FROM DESSUB WHERE VENCI='30.12.2017' 
SELECT * FROM DESSUB WHERE VENCI='31.12.2017' 
SELECT * FROM DESSUB WHERE VENCI='30.12.2017' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE VENCI='30.12.2017' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM viewliq WHERE PKEMP='762' 
SELECT * FROM viewliq WHERE PKEMP='761' 
SELECT * FROM DESSUB WHERE PKEMP='761' 
SELECT FIRST 1 * FROM GEN_ID_CONTAS
update GEN_ID_CONTAS set nempg='1', ordpg='0', nempgex='0', nempgre='0', nextra='0', ordpgpk='0'
SELECT * FROM DESPES
SELECT * FROM TABEMPRESa
SELECT NEMPG FROM TABEMPRESa
SELECT  * FROM BANCOS
SELECT * FROM DESCON
SELECT FIRST 1 * FROM DESCONSALDOBANCO
SELECT * FROM DESCONSALDOBANCO
SELECT * FROM DESCON_DETALHE
SELECT * FROM DESCONSALDOBANCO
SELECT * FROM DESCON
SELECT * FROM DESCON_DETALHE
SELECT * FROM DESCON
SELECT * FROM DESCON_DETALHE
select * from conpla_scpi
SELECT * FROM desdis
SELECT * FROM extra
select * from desdis where extra='S'
select * from desdis
DELETE FROM CONFIG_SCPI WHERE MODULO = 'DIARIO-RAZAO' AND PARAMETRO = 'INC_ALMO_ENTR'
select * from pt_cadpat
select * from pt_cadpat where codigo_bai_pat is null
select * from pt_cadpat where codigo_bai_pat is null and codigo_tip_pat<>21
select * from pt_cadpat where codigo_bai_pat is null and codigo_tip_pat=21
select * from pt_cadpat
select * from despes where pkemp = 988
select * from viewliq where pkemp = 988
delete from dessub where pkemp = 988
delete from viewliq where pkemp = 988
select * from viewliq where pkemp = 988
select * from despes where pkemp = 988
delete from despes where pkemp = 988
select * from despes where pkemp = 988
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
select * from pt_cadpat
select * from pt_cadpat where chapa_pat = 000314
select * from pt_cadpat
select * from pt_cadpat where chapa_pat = 000314
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SELECT * FROM DESPES
SELECT * FROM DESPES WHERE TPEM = 'EX'
SELECT * FROM desdis
SELECT FIRST 1 * FROM GEN_ID_CONTAS
SELECT * FROM DESCON_DETALHE
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SELECT * FROM DESPES
SELECT * FROM DESPES WHERE TPEM = 'EX'
SELECT  * FROM DESPESITEM
SELECT * FROM ORDPAG
SELECT * FROM ORDCRE
UPDATE ORDCRE SET CONTAD = 3
SELECT * FROM ORDCRE
SELECT * FROM ORDCRE WHERE CONTAD > 1
SELECT * FROM ORDCRE WHERE CONTAD > 3
UPDATE ORDCRE SET CONTAD = 3 WHERE CONTAD > 3
SELECT * FROM RECEIT
SELECT * FROM RECEIT WHERE CONTAD > 3
UPDATE RECEIT SET CONTAD = 3 WHERE CONTAD > 3
SELECT * FROM RECEIT WHERE CONTAD > 3
SELECT * FROM RECEIT WHERE CONTAD > 2
SUPDATE RECEIT SET CONTAD = 3 WHERE CONTAD > 2
UPDATE RECEIT SET CONTAD = 3 WHERE CONTAD > 2
SELECT * FROM RECEIT
SELECT * FROM ORDPAG
select * from dessub_retencao
SELECT * FROM DESCON_DETALHE
SELECT * FROM DESCON
SELECT * FROM ORDPAG
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SELECT * FROM ORDPAG
SELECT * FROM despes
SELECT * FROM ORDCRE
SELECT * FROM desdis
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SUPDATE RECEIT SET CONTAD = 3 WHERE CONTAD > 2
SELECT * FROM RECEIT WHERE CONTAD > 3
SELECT * FROM RECEIT WHERE CONTAD > 2
SELECT FIRST 1 * FROM GEN_ID_CONTAS
select * from condia_tce WHERE SEQ_SAGRES='0'
select * from condia_tce
SELECT gen_id(GEN_CONDIA_TCE, ((90397620) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE;
SELECT gen_id(GEN_CONDIA_TCE, ((90397624) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE;
SELECT gen_id(GEN_CONDIA_TCE, ((90214397) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE;
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SELECT * FROM ORDCRE
SELECT * FROM despes
SELECT * FROM desdis
SELECT * FROM ORDPAG
SELECT * FROM DESCON_DETALHE
SELECT * FROM despes
SELECT * FROM desdis
SELECT * FROM despes
SELECT VINGRUPO, VINCODIGO FROM despes
UPDATE DESPES SET VINGRUPO = '001', VINCODIGO = '001'
SELECT VINGRUPO, VINCODIGO FROM despes
SELECT * FROM DESCON_DETALHE
SELECT * FROM DESCON
SELECT * FROM DESCON_DETALHE
SELECT * FROM desdis
SELECT * FROM ORDPAG
SELECT * FROM ORDCRE
SELECT * FROM DESCON
SELECT * FROM desdis
SELECT * FROM DESDIS
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
UPDATE condia_tce SET FORN_TIPO='1', FORN_IDENT='29979036000140' where SEQUENCIA IN ('90294235', '90294236','90294237','90294238')
SELECT * FROM CONDIA_TCE
SELECT * FROM CONDIA_TCE WHERE  IE='10'
SELECT * FROM CONDIA_TCE WHERE  IE='10' AND DATAE BETWEEN '31.12.2020' AND '31.12.2020'
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
ALTER TABLE CADPRO_SALDO_ANT_FIC ADD SUBDESDOBRO VARCHAR(11) NOT NULL;
SELECT * FROM CONDIA_TCE
SELECT * FROM CONDIA_TCE WHERE DATAE = '01.01.2021'
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SELECT FIRST 1 * FROM CONTROLE_EXTRA
DESPES
SELECT FIRST 1 * FROM despes
SELECT * FROM CONDIA_TCE WHERE IE IN ('0','1')
SELECT * FROM CONDIA_TCE WHERE IE IN ('0')
SELECT * FROM CONDIA_TCE WHERE IE IN ('0','1')
UPDATE TABEMPRESA SET TRAVA =NULL, TRAVADIARIO =NULL, TRAVAFINAL =NULL
SELECT * FROM CONDIA_TCE WHERE IE IN ('0','1')
SELECT FIRST 1 * FROM DESPES
SELECT * FROM CADPRO_ATESTADODESEMP
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM CONDIA_TCE
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA = 30181
SELECT * FROM CONDIA_TCE
SELECT * FROM CONDIA_TCE WHERE DATAE = '31.01.2020'
SELECT * FROM CONDIA_TCE WHERE DATAE = '31.01.2020' AND IE = 10
SELECT * FROM CONDIA_TCE WHERE DATAE = '20.01.2020'
SELECT * FROM TABEMPRESA
SELECT * FROM CADORC
SELECT * FROM FCADPED
SELECT * FROM DESPES
SELECT * FROM CONDIA_TCE WHERE DATAE > '31.07.2020'
DELETE FROM CONDIA_TCE WHERE DATAE > '31.07.2020' AND DATAE < '01.09.2020'
SELECT * FROM CONDIA_TCE WHERE DATAE > '31.07.2020' AND DATAE < '01.09.2020'
DELETE FROM CONDIA_TCE WHERE DATAE > '31.07.2020' AND DATAE < '01.09.2020'
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM CONDIA_TCE
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%'
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%' AND DATAE='31.01.2020'
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%'
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%' AND DATAE='31.01.2020'
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%' AND SEQUENCIA = 64863
select * from tabempresa
SELECT * FROM DESDIS
SELECT * FROM DESPES
SELECT * FROM CADORC
SELECT * FROM DESDIS
SELECT * FROM DESPES
SELECT * FROM DESORC
UPDATE DESORC SET FONTE_STN = '1.500'
SELECT * FROM DESORC
select * from tabempresa
SELECT FIRST 1 * FROM CADPAT
SELECT * FROM CADPAT
SELECT * FROM PT_CADPAT
UPDATE PT_MOVBEM SET DTAINSERE='30.09.2021' WHERE DT_CONTABIL='30.09.2021'
SELECT * FROM PT_CADPAT
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='000894'
UPDATE PT_CADPAT SET DTAINSERE='01.09/2021 08:36:29' WHERE CHAPA_PAT='000894'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='000894'
SELECT * FROM CADPAT
SELECT * FROM PT_CADPAT
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='000894'
UPDATE PT_CADPAT SET ORIG_PAT='O' WHERE CHAPA_PAT='000894'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='000894'
UPDATE PT_CADPAT SET ORIG_PAT='I' WHERE CHAPA_PAT='000894'
UPDATE PT_CADPAT SET ORIG_PAT='I' WHERE CHAPA_PAT IN ('000901','000902','000906')
SELECT * FROM PT_MOVBEM
SELECT * FROM PT_MOVBEM  WHERE DATA_MOV='30.07.2021'
update tabempresa set trava=null, travadiario=null, travafinal= null
UPDATE PT_MOVBEM SET DATA_MOV='30.09.2021', DTDOCUM_MOV='30.09.2021', DT_CONTABIL='30.09.2021', DTAINSERE='30.09.2021'   WHERE DATA_MOV='30.07.2021'
UPDATE PT_CADPAT SET ORIG_PAT='I' WHERE CHAPA_PAT IN ('000901','000902','000906')
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT='000894'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT IN ('000894','000901','000902','000906')
UPDATE PT_CADPAT SET ORIG_PAT='I' WHERE CHAPA_PAT IN ('000901','000902','000906')
UPDATE PT_MOVBEM SET DATA_MOV='30.09.2021', DTDOCUM_MOV='30.09.2021', DT_CONTABIL='30.09.2021', DTAINSERE='30.09.2021'   WHERE DATA_MOV='30.09.2021'
SELECT * FROM PT_MOVBEM  WHERE DATA_MOV='30.07.2021'
SELECT * FROM PT_MOVBEM  WHERE DATA_MOV='30.09.2021'
SELECT * FROM PT_MOVBEM  WHERE DATA_MOV='02.09.2021'
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM PT_CADPAT
SELECT * FROM PT_MOVBEM
SELECT * FROM PT_CADPAT
SELECT * FROM PT_CADPAT WHERE CODIGO_PAT > 681
SELECT * FROM PT_MOVBEM
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T'
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T' AND DATA_MOV > '31.08.2021'
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T' AND DATA_MOV > '31.08.2021'
DELETE FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T' AND DATA_MOV > '31.08.2021'
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
DELETE FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T'
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T'
DELETE FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV <> 'T'
SELECT * FROM PT_CADPAT WHERE CODIGO_PAT > 681
UPDATE PT_CADPAT SET DTAINSERE = '01/09/2021 08:36:29' WHERE CODIGO_PAT > 681
SELECT * FROM PT_CADPAT WHERE CODIGO_PAT > 681
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
DELETE FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
SELECT  * FROM PT_HISCHAPA
SELECT  * FROM PT_CADBAI
SELECT  * FROM PT_CADPATD
SELECT  * FROM PT_CADPATS
SELECT  * FROM PT_CADSIT
SELECT  * FROM PT_CADTIP
SELECT  * FROM PT_TIPOMOV
SELECT  * FROM PT_TIPOPROCMOV
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
DELETE FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
SELECT  * FROM PR_BAIXADIVIDA
SELECT  * FROM PT_CADRESPONSAVEL
SELECT * FROM PT_CONPLA_TCE
SELECT  * FROM PT_HISCHAPA
SELECT  * FROM PT_MANUTENCAO
SELECT * FROM PT_SINCRONIZADOR
SELECT  * FROM PT_TIPOMOV
SELECT  * FROM PT_TIPOPROCMOV
SELECT * FROM PT_INVENTARIO_BEM_NC
SELECT  * FROM PT_CADAJUSTE
SELECT  * FROM PT_CADPAT
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV = 'B'
update tabempresa set trava = null, travadiario= null, travafinal = null;
DELETE FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND TIPO_MOV = 'B'
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681 AND VALOR_MOV < '0'
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV > 681
SELECT * FROM PT_MOVBEM WHERE DATA_MOV > '31.08.2021'
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM PT_MOVBEM WHERE DATA_MOV > '31.08.2021'
SELECT * FROM PT_MOVBEM WHERE DATA_MOV > '31.08.2021' AND TIPO_MOV = 'B'
SELECT * FROM DESPES
update tabempresa set trava = null, travadiario= null, travafinal = null;
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%' AND DATAE='31.12.2020'
SELECT * FROM CONDIA_TCE WHERE SEQUENCIA = '235531' AND DATAE='31.12.2020'
SELECT * FROM CONDIA_TCE WHERE BALCO LIKE '%2188%' AND DATAE='31.12.2020'
SELECT * FROM DESDIS
SELECT * FROM DESPES
SELECT * FROM DESPES WHERE TPEM = 'EX'
select * FROM RATEIO_PAGAMENTO WHERE ORDPG=127
select * FROM RATEIO_PAGAMENTO
select * FROM ORDPAG
select * FROM ORDPAG WHERE ORDPG = 30
select * FROM ORDPAG
select * FROM ORDPAG WHERE CODIF = 14
select * FROM ORDPAG WHERE CODIF = 14 AND DTPAG IS NULL
select * FROM despes
select * FROM despes where tpem = 'ex'
select * FROM despes
select * FROM despes where tpem ='EX'
update tabempresa set trava = null, travadiario= null, travafinal = null;
select * from  tabempresa
SELECT *  FROM CADEST
SELEC * FROM CONFIG
SELEC * FROM COMPLA_TCE
select * from  tabempresa
select * FROM despes where tpem ='EX'
select * FROM despes where tpem ='EX' AND DATAE = '19.11.2021'
SELECT * FROM RECEIT
SELECT * FROM RECEIT WHERE DTREC = '19.11.2021'
SELECT * FROM ORDCRE
SELECT * FROM ORDCRE WHERE DTLAN = '19.11.2021'
SELECT * FROM RECEIT WHERE DTREC = '19.11.2021'
SELECT * FROM ORDCRE WHERE DTLAN = '19.11.2021'
SELECT * FROM RECEIT WHERE DTREC = '19.11.2021'
select * from  tabempresa
select * FROM despes where tpem ='EX'
select * FROM despes where tpem ='EX' AND FICHA = 9003
update despes set codif = 51 where tpem ='EX' AND FICHA = 9003 and codif = 1
select * FROM despes where tpem ='EX' AND FICHA = 9003
select * FROM despes where tpem ='EX' AND FICHA = 9003 AND PRODU <> '(MEMO)'
select * FROM despes where tpem ='EX' AND FICHA = 9003 AND VENCI IS NULL
SELECT * FROM despes where tpem ='EX' AND FICHA = 9003 AND VENCI IS NULL
SELECT * FROM despes where tpem ='EX' AND VENCI IS NULL
select * from GEN_ID_CONTAS
UPDATE GEN_ID_CONTAS SET NEMPG =493
UPDATE GEN_ID_CONTAS SET NEMPGEX =87
select * from DESPES
select * from DESPES WHERE TPEM='OR'
ALTER SEQUENCE GEN_DESPES RESTART WITH EMPENHO
select * from GEN_ID_CONTAS
UPDATE GEN_ID_CONTAS SET NEMPG ='494'
select * from DESPES WHERE TPEM='OR'
UPDATE DESPES SET NEMPG='495' WHERE TPEM='OR' and nempg='517'
UPDATE GEN_ID_CONTAS SET NEMPG ='496'
UPDATE GEN_ID_CONTAS SET NEMPG ='493'
select * from GEN_ID_CONTAS
select * from  tabempresa
select * from DESPES WHERE TPEM='es'
select * from DESPES WHERE TPEM='ES'
select * from  tabempresa
SELECT * FROM DESDIS
SELECT * FROM DESORC
SELECT FIRST 1 * FROM LDOPROG
SELECT * FROM LDOPROG
SELECT * FROM LDO_DESPESA
SELECT * FROM LDOACOES
SELECT * FROM LDO_AUDESP
SELECT * FROM LDO_COMPARADA
SELECT * FROM LDO_META
SELECT * FROM LDO_DESPESA
SELECT * FROM PPA_PROGRAMA
SELECT * FROM PPA_CADDESPESA
SELECT * FROM PPA_ACOES
SELECT * FROM PPA_ACOES_APURA
SELECT * FROM PPA_DESPESA
SELECT * FROM PPA_METAALT
SELECT * FROM PPA_METAS
SELECT * FROM PPA_METAS_EXEC
SELECT * FROM PPA_PROGALT
SELECT * FROM PPA_PROGODS
SELECT * FROM PPA_PROGRAMA
SELECT * FROM PPACADDESPES
SELECT * FROM PPADESPES
SELECT * FROM PPAPROG
SELECT * FROM LDOACOES
SELECT * FROM LDOPROG
SELECT * FROM LDoacoes
SELECT * FROM PPA_PROGRAMA
SELECT * FROM PPA_METAS
SELECT * FROM PPA_ACOES
select * from  tabempresa
SELECT *  FROM NOTA
SELECT *  FROM DESPES
select * from  tabempresa
SELECT *  FROM NOTA
SELECT * FROM PT_CADPAT
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000707'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000706'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000707'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000706'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000707'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000706'
select * from  tabempresa
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000706'
SELECT * FROM PT_CADPAT WHERE CODIGO_GRU_PAT = '0'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000706'
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT = '000707'
select * from  tabempresa
select * from  ppa_acoes
select * from  tabempresa 
SELECT *  FROM DESPES 
SELECT * FROM PPACADDESPES 
SELECT * FROM DESDIS 
select * FROM despes where tpem ='EX' AND FICHA = 9003 
SELECT * FROM RECEIT 
SELECT * FROM RECEIT WHERE FK_DESCON_DETALHE > 2 
UPDATE RECEIT SET FK_DESCON_DETALHE = 2 WHERE FK_DESCON_DETALHE > 2 
SELECT * FROM condia_tce where IE = 10 
select * from GEN_ID_CONTAS 
SELECT gen_id(GEN_CONDIA_TCE, ((267879) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
SELECT * FROM DESDIS 
SELECT * FROM DESpes 
SELECT * FROM DESpes where tpem = 'WX' 
SELECT * FROM DESpes where tpem = 'EX' 
select * from  tabempresa 
select * from  condia_tce 
select * from  condia_tce where balco = '89551000000' 
select * from  condia_tce where balco = '89551000000' and sequencia = 22929 
SELECR * FROM DESPES 
SELECT * FROM DESPES 
SELECT * FROM DESPES WHERE TPEM = 'EX' 
select * from  condia_tce where balco = '89551000000' 
select * from  tabempresa 
SELECT gen_id(GEN_CONDIA_TCE, ((90188615) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  tabempresa 
SELECT gen_id(GEN_CONDIA_TCE, ((90188242) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce 
select * from  condia_tce where datae = '31.01.2022' 
select * from  condia_tce where datae = '31.01.2022' and ie = '10' 
select * from  condia_tce where datae = '31.01.2022' 
select * from  condia_tce where datae = '31.01.2022' and balco > '6' and balco < '7' 
select * from  condia_tce where datae = '31.01.2022' and balco > '5' and balco < '7' 
select * from  condia_tce where datae = '31.01.2022' and balco > '5' and balco < '6' 
select * from  tabempresa 
select * from  condia_tce where datae = '28.02.2022' and balco > '5' and balco < '6' 
select * from  condia_tce where datae = '28.02.2022' and balco > '5' and balco < '7' 
select * from  condia_tce where datae = '31.03.2022' and balco > '5' and balco < '7' 
select * from  condia_tce where datae > '25.02.2022' and balco > '5' and balco < '7' and evento = '8.R.001.2' 
select * from  condia_tce where datae = '31.01.2022' and balco > '5' and balco < '6' 
select * from  tabempresa 
SELECR * FROM RECEIT 
SELECR * FROM RECEITA 
SELECT * FROM DESPES WHERE TPEM = 'EX' 
SELECR * FROM recdis 
SELECT * FROM recdis 
SELECT * FROM desdis 
SELECT * FROM recdis 
SELECT * FROM desdis 
select * from  tabempresa 
SELECT * FROM desdis 
SELECT * FROM despes where datae > '04.04.2022' 
update despes set datae = '11.04.2022' where datae > '04.04.2022' 
SELECT * FROM despes where datae > '01.03.2022' 
SELECT * FROM despes where elemento = 14 
SELECT * FROM despes where datae > '01.03.2022' AND ELEMENTO = 14 
SELECT * FROM despes where datae > '01.04.2022' AND ELEMENTO = 14 
SELECT * FROM condia_tce where IE = 10 
SELECT * FROM condia_tce where IE = 4 
SELECT * FROM condia_tce where IE =10 
SELECT * FROM condia_tce where IE = 4 
SELECT * FROM condia_tce where IE =10 
SELECT * FROM condia_tce where IE = 4 
SELECT * FROM condia_tce where IE = 13 
SELECT * FROM condia_tce where IE = 33 
SELECT * FROM condia_tce where IE = 33 and balco =  72111000000 
SELECT * FROM condia_tce where IE = 33 and balco =  72113000000 
SELECT * FROM condia_tce where IE = 33 and balco =  72111000000 
SELECT * FROM condia_tce where IE =10 
SELECT * FROM condia_tce where IE = 33 and balco =  72111000000 
SELECT * FROM condia_tce where IE =10 
SELECT gen_id(GEN_CONDIA_TCE, ((37525) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce where datae > '31.01.2022' 
select * from  condia_tce where datae > '31.01.2022' and fonro > 0 
select * from  condia_tce where fonro > 0 
update condia_tce set fonro = 0 where fonro > 0 
SELECT * FROM condia_tce where IE =10 
update condia_tce set fonro = 0 where fonro > 0 
SELECT gen_id(GEN_CONDIA_TCE, ((17770) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  tabempresa 
update condia_tce set fonro = 0 where fonro > 0 
SELECT * FROM condia_tce where IE =10 
SELECT gen_id(GEN_CONDIA_TCE, ((18392) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
SELECT gen_id(GEN_CONDIA_TCE, ((17770) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
SELECT gen_id(GEN_CONDIA_TCE, ((18952) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce where fonro > 0 
select * from  condia_tce where SEQUENCIA = 18954 
select * from  condia_tce where SEQUENCIA > 18954 
select * from  condia_tce where SEQUENCIA > 18954  AND DATAE > '27.02.2022' 
SELECT gen_id(GEN_CONDIA_TCE, ((20128) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
SELECT gen_id(GEN_CONDIA_TCE, ((18392) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce where SEQUENCIA > 18954  AND DATAE > '01.03.2022' 
select * from  condia_tce where DATAE > '01.03.2022' 
select * from  condia_tce where DATAE = '28.02.2022' 
SELECT gen_id(GEN_CONDIA_TCE, ((20129) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce where fonro > 0 
update condia_tce set fonro = 0 where fonro > 0 
SELECT * FROM condia_tce where IE =10 
update condia_tce set fonro = 0 where fonro > 0 
select * from  condia_tce where fonro > 0 
select * from  tabempresa 
select * from  condia_tce where fonro > 0 
update condia_tce set fonro = 0 where fonro > 0 
SELECT * FROM condia_tce where IE =10 
select * from  condia_tce where DATAE = '13.04.2022' 
SELECT * FROM condia_tce where IE =10 
SELECT * FROM DESPES 
SELECT * FROM DESPES WHERE NEMPG = 146 
SELECT * FROM DESPES 
SELECT * FROM DESPES where DATAE > '01.04.2022' AND DATAE < '02.05.2022' AND TPEM = 'OR' 
SELECT * FROM DESPES WHERE NEMPG = 146 
SELECT * FROM DESPES where DATAE = '15.04.2022' 
UPDATE DESPES SET DATAE = '08.04.2022' where DATAE = '15.04.2022' 
SELECT * FROM PPA_PROGRAMA 
SELECT * FROM PPA_ACOES 
select * from  tabempresa 
SELECT * FROM condia_tce where IE =10 
SELECT * FROM DESPES WHERE NEMPG = 146 
select * from  condia_tce where fonro > 0 
update condia_tce set fonro = 0 where fonro > 0 
select * from  tabempresa 
SELECT * FROM DESPES where DATAE = '15.04.2022' 
SELECT * FROM DESPES where DATAE > '01.04.2022' AND DATAE < '02.05.2022' AND TPEM = 'OR' 
SELECT * FROM DESPES where DATAE > '04.07.2022' 
update DESPES set DATAE = '04.07.2022' where DATAE > '04.07.2022' 
SELECT * FROM DESPES where DATAE = '04.07.2022' 
SELECT * FROM VIEWLIQ 
SELECT * FROM VIEWLIQ WHERE DATAE > '06.06.2022' 
SELECT * FROM VIEWLIQ WHERE DATAE > '30.06.2022' 
UPDATE VIEWLIQ SET CODIF_RESPATESTO = '823' WHERE DATAE > '30.06.2022' 
SELECT * FROM VIEWLIQ WHERE DATAE > '30.06.2022' 
select * from  tabempresa 
SELECT * FROM VIEWLIQ WHERE DATAE > '30.06.2022' 
select * from  tabempresa 
select * from  condia_tce where fonro > 0 
select * from  condia_tce where datae < '31.01.2022' 
select * from  condia_tce where fonte_stn = '1.501' 
select * from  condia_tce where balco = '11111020000' and datae = '19.01.2022' 
select * from  condia_tce where balco = '11111020000' and datae = '19.01.2022' and debit = '8024.41' 
select * from  condia_tce where datae = '19.01.2022' and debit = '8024.41' 
select * from  tabempresa 
SELECT * FROM condia_tce where IE =10
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
UPDATE GEN_ID_CONTAS  SET NEMPG = 460 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
SELECT * FROM GEN_ID_CONTAS 
DELETE FROM  DESPES WHERE PKEMP = 716 
DELETE FROM  VIEWLIQ WHERE PKEMP = 716 
DELETE FROM  DESSUB WHERE PKEMP = 716 
DELETE FROM  DESPES WHERE PKEMP = 716 
SELECT *  FROM  DESSUB WHERE PKEMP = 716 
SELECT *  FROM  VIEWLIQ  WHERE PKEMP = 716 
SELECT * FROM   DESPES WHERE PKEMP = 716 
SELECT *  FROM  VIEWLIQ  WHERE PKEMP = 716 
SELECT * FROM   DESPES WHERE PKEMP = 716 
SELECT *  FROM  VIEWLIQ  WHERE PKEMP = 716 
SELECT *  FROM  VIEWLIQ 
SELECT *  FROM  VIEWLIQ WHERE PK_VIEWLIQ  = 765 
SELECT PK_VIEWLIQ FROM  VIEWLIQ 
SELECT * FROM   DESPES WHERE PKEMP = 716 
SELECT *  FROM  VIEWLIQ WHERE PK_VIEWLIQ  = 765 
SELECT FIRST 1 * FROM GEN_ID_COMPRAS 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
SELECT FIRST 1 * FROM GR_GENERICO 
SELECT FIRST 1 * FROM ADP_CAD_GENERICA 
SELECT FIRST 1 * FROM GEN_ID_COMPRAS 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
SELECT (pk_viewliq) FROM VIEWLIQ 
SELECT (pk_dessub) FROM dessub 
SELECT * FROM VIEWLIQ    where pkemp=716 
SELECT * FROM dessub    where pkemp=716 
SELECT * FROM viewliq    where pkemp=716 
SELECT * FROM despes    where pkemp=716 
SELECT * FROM dessub    where pkemp=716 
SELECT * FROM viewliq    where pkemp=716 
SELECT * FROM despes    where pkemp=716 
SELECT FIRST 1 * FROM DESPES 
SELECT  * FROM DESPES 
SELECT fk_despes FROM DESPES 
SELECT  * FROM DESPES      where nempg=461 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
SELECT * FROM DESPES 
SELECT * FROM DESPES    where nempg > '740' 
SELECT * FROM DESPES    where nempg > '470' 
SELECT * FROM DESPES    where nempg > '460' 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
update GEN_ID_CONTAS   set nempg=473 
SELECT  * FROM DESFOR 
SELECT  pk_desfor FROM DESFOR 
SELECT  * FROM ORDCAI 
SELECT  * FROM ORDCAI   where conta='104' 
SELECT  * FROM ORDCAI   where conta='104'          and dtlan between '01.09.2022' and '30.09.2022' 
SELECT  * FROM ORDCre   where conta='104'          and dtlan between '01.09.2022' and '30.09.2022' 
SELECT  * FROM receit   where conta='104'          and dtlan between '01.09.2022' and '30.09.2022' 
SELECT  * FROM ORDCAIbanco   where conta='104' 
SELECT  * FROM ORDCAIbanco   where conta='104'         and dtcontabilizado between '01.09.2022' and '30.09.2022' 
select * from condia_tce where ie=13 
select * from  tabempresa 
select * from condia_tce where ie=13 
select * from condia_tce where ie=10 
SELECT  * FROM CONDIA_TCE    where balco like '611%' 
select * from  tabempresa 
select * from condia_tce where ie=10 
SELECT gen_id(GEN_CONDIA_TCE, ((90227740) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce where datae > '28.02.2022' 
select * from  condia_tce where datae > '28.02.2022' and datae < '01.04.2022' 
select * from  condia_tce where datae > '28.02.2022' 
select * from  condia_tce where datae > '28.02.2022'  order by datae 
delete from condia_tce where datae > '28.02.2022' 
select * from  condia_tce where datae > '28.02.2022'  order by datae 
select * from condia_tce where ie=10 
SELECT gen_id(GEN_CONDIA_TCE, ((90231534) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from  condia_tce where datae > '28.02.2022'  order by datae 
delete from condia_tce where datae > '28.02.2022' 
SELECT gen_id(GEN_CONDIA_TCE, ((90231534) - (SELECT gen_id(GEN_CONDIA_TCE,0) FROM RDB$DATABASE))) FROM RDB$DATABASE; 
select * from condia_tce where ie=10 
select * from  tabempresa 
select * from condia_tce where ie=10 
select * from  condia_tce where datae > '31.05.2022'  order by datae 
DELETE from  condia_tce where datae > '31.05.2022'  order by datae 
select * from condia_tce where ie=10 
select * from  cadpat 
SELECT * FROM MODELO_RTF 
SELECT * FROM MODELO_RTF
SELECT * FROM MODELO_RTF 
delete FROM MODELO_RTF 
SELECT * FROM DESPES 
SELECT * FROM DESPES WHERE PKEMP = 779 
SELECT * FROM VIEWLIQ WHERE PKEMP = 779 
SELECT * FROM VIEWLIQ WHERE PKEMP = 778
SELECT * FROM VIEWLIQ WHERE PKEMP = 779 
SELECT * FROM VIEWLIQ WHERE PKEMP = 778 
SELECT * FROM VIEWLIQ WHERE PKEMP = 778
SELECT * FROM dessub WHERE PKEMP = 778 
SELECT * FROM dessub WHERE PKEMP = 778
SELECT * FROM VIEWLIQ WHERE PKEMP = 778 
SELECT * FROM despes WHERE PKEMP = 778 
SELECT * FROM despes WHERE nempg = 497 
SELECT * FROM VIEWLIQ WHERE PKEMP = 778 
SELECT * FROM despes WHERE PKEMP = 778 
SELECT * FROM despes WHERE nempg = 497 
SELECT * FROM VIEWLIQ WHERE PKEMP = 778 
SELECT * FROM despes where nempg=555 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
update GEN_ID_CONTAS    set nempg=554 
select * from condia_tce where ie=4 
select * from condia_tce where ie=4 and datae = '07.10.2022' 
select * from condia_tce where ie=10 
select * from despes where nempg=599 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
update GEN_ID_CONTAS   set nempg=598 
select * from despes where nempg=555 
update tabempresa set trava = null, travadiario= null, travafinal = null; 
UPDATE SENHA SET TABDEF_EXECUCAO = NULL WHERE TABDEF_EXECUCAO = 'S' 
SELECT * from tabempresa 
UPDATE SENHA SET TABDEF_EXECUCAO = NULL WHERE TABDEF_EXECUCAO = 'S' 
SELECT * from despes where nempg=613 
SELECT FIRST 1 * FROM GEN_ID_CONTAS 
delete from condia_tce where ie=4 and datae >='01.12.2022' 
SELECT * from condia_tce where balco like '5311%' 
SELECT * from condia_tce where balco like '5311%'  and datae >= '01.12.2022' 
SELECT * from condia_tce where balco like '5311%' 
SELECT fonte_stn from condia_tce where balco like '5311%' 
SELECT * from condia_tce where balco like '5311%' 
select fonte_stn from condia_tce where balco like '5311%' 
update condia_tce set fonte_stn='1.500' where balco like '5311%'     and datae >='01.12.2022' 
update condia_tce set fonte_stn='1.500' where balco like '5312%'     and datae >='01.12.2022' 
SELECT  * FROM DESPES 
SELECT  * FROM DESPES        where tpem='OR' 
SELECT  * FROM DESPES        where tpem in ('OR','ES') 
SELECT  * FROM DESPES        where tpem in ('OR','ES','GL','AD') 
select * from despes where nempg='8' 
select * from despes 
select * from despes  where nempg='14' 
select * from despes where nempg='8' 
select * from extra 
select * from recdis 
select * from desdis 
SELECT * FROM DESPES 
SELECT * FROM DESPES   WHERE     TPEM <> 'EX' 
select * from gen_id_contas 
SELECT * FROM extra 
SELECT * FROM extra    where BALCO='323299' 
SELECT * FROM extra    where BALCO_TCE='21881011500' 
SELECT * FROM extra 
SELECT * FROM extra where CODIF='591' 
SELECT * FROM extra    where BALCO_TCE='33311010100' 
SELECT * FROM condia_Tce    where BALCO='33311010100'         and ie=34 
select * from condia_Tce where evento='8.15.01'           and datae >= '01.12.2022'          and ie=33        and foncodigo=500 
delete FROM condia_Tce    where  ie=1 
update condia_Tce set foncodigo=500    where  foncodigo is null 
update condia_Tce set foncodigo=500    where  foncodigo=00 
delete FROM condia_Tce    where  ie=1 
update condia_Tce set foncodigo=500    where  foncodigo is null 
update condia_Tce set foncodigo=500    where  foncodigo=00 
delete FROM condia_Tce    where  ie=1 
SELECT * FROM DESPES   WHERE     TPEM <> 'EX' 
select * from condia_Tce where evento='8.15.01'           and datae >= '01.12.2022'          and ie=33        and foncodigo=500 
select * from condia_Tce where evento='8.15.01'           and datae >= '01.12.2022'          and ie=33        and foncodigo=500  and balco like '6111%' 
select * from condia_Tce where evento='8.15.01'           and datae >= '01.12.2022'          and ie=33        and foncodigo=500  and balco like '6112%' 
select * from condia_Tce where evento='8.15.01'           and datae >= '01.12.2022'          and ie=33        and foncodigo=500  and balco like '5111%' 
delete FROM condia_Tce    where  ie=1 
delete FROM condia_Tce    where  ie=0 
update condia_Tce set foncodigo=500    where  foncodigo=00 
update condia_Tce set foncodigo=500    where  foncodigo IS NULL 
select * from viewliq 
select * from viewliq where pkemp='8' 
select * from viewliq 
select * from viewliq where pkemp='23' 
select * from viewliq 
select * from viewliq where pkemp='24' 
select * from viewliq where pkemp='23' 
select * from condia_tce 
select * from condia_tce           where debit='698.53'     or            credi='698.53' 
SELECT FIRST 1 * FROM TABEMPRESA 
select * from DESCSUB WHERE PKEMP=913 
select * from receit WHERE dtlan='20.12.2022' 
select * from receit WHERE dtlan='20.12.2022'     and conta =104 
select * from condia_tce where credi='698.53' or debit='698.53' 
select * from DESCSUB WHERE PKEMP=913 
select * from DESSUB WHERE PKEMP=973 
select * from DESCSUB WHERE PKEMP=973 
select * from DESSUB WHERE PKEMP=973 
select * from condia_tce where evento='8.15.01' 
select * from condia_tce where evento='8.15.01'      and balco like '5111%' 
select * from condia_tce where evento='8.15.01'      and balco like '6111%' 
select * from condia_tce where evento='8.15.01'      and balco like '6112%' 
UPDATE SENHA SET TABDEF_EXECUCAO = NULL WHERE TABDEF_EXECUCAO = 'S' 
SELECT * FROM TABEMPRESA 
select * from dessub where pkemp = '142' 
select * from viewliq where pkemp = '142' 
select * from dessub where pkemp = '142' 
SELECT * FROM PT_CADPAT 
Update PT_CADPAT set dt_contabil=datae_pat where datae_pat >= '24.04.2023' 
SELECT * FROM PT_CADPAT 
select * from dessub where pkemp = '142' 
select * from dessub where pkemp = '422' 
dessub
select * from despes where pkemp = '422' 
select * from viewliq where pkemp = '422' 
select * from despes where pkemp = '422' 
select * from extra where extra=9014 
select * from despes
UPDATE CADCLI SET TRAVA = NULL , TRAVADIARIO =NULL 
delete from dessub  
delete from viewliq  
delete from despes  
SELECT FIRST 1 * FROM CONDIA_TCE
SELECT * FROM TABEMPRESA
SELECT * FROM PT_MOVBEM 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV='31.03.2024' 
DELETE FROM PT_MOVBEM WHERE DATA_MOV='31.03.2024' 
SELECT FIRST 1 * FROM PT_CADPAT
SELECT PKEMP FROM DESPES WHERE NEMPG=594
SELECT * FROM PT_CADPAT WHERE CODIGO_PKEMP_PAT=52
SELECT * FROM PT_CADPAT
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT BETWEEN 001164 AND 001220
UPDATE PT_CADPAT SET DATAE_PAT='04.03.2024', DTLAN_PAT='04.03.2024', DT_CONTABIL='04.03.2024'  WHERE CHAPA_PAT BETWEEN 001164 AND 001220
SELECT * FROM PT_CADPAT WHERE CHAPA_PAT=11072
SELECT * FROM PT_CADPAT WHERE DATAE_PAT='04.03.2024'
SELECT * FROM PT_MOVBEM 
SELECT * FROM PT_MOVBEM WHERE DATA_MOV='04.03.2024'
SELECT * FROM PT_MOVBEM 
SELECT * FROM PT_MOVBEM WHERE CODIGO_MOV = '1167'
SELECT * FROM PT_MOVBEM WHERE CODIGO_MOV = '1101'
select * from cadlic 
SELECT * FROM PT_MOVBEM 
SELECT * FROM PT_MOVBEM where codigo_mov=91353 
delete FROM PT_MOVBEM where codigo_mov=91353 
SELECT * FROM PT_MOVBEM where DT_CONTABIL='01.07.2024'
SELECT * FROM PT_MOVBEM where DATA_MOV='30.06.2024'
DELETE FROM PT_MOVBEM where LOTE_MOV=2926
SELECT * FROM PT_MOVBEM WHERE DATA_MOV='24.06.2024'
SELECT * FROM PT_MOVBEM WHERE LOTE_MOV=2945
DELETE FROM PT_MOVBEM WHERE LOTE_MOV=2945
SELECT *  FROM PT_MOVBEM WHERE LOTE_MOV=2945
SELECT * FROM PT_CADPAT WHERE NOTA_PAT= '23835484'
UPDATE PT_CADPAT SET DATAE_PAT='12.08.2024', DTLAN_PAT='12.08.2024', DT_CONTABIL='12.08.2024' WHERE NOTA_PAT= '23835484'
SELECT * FROM PT_CADPAT WHERE NOTA_PAT= '23835484'
SELECT * FROM PT_MOVBEM WHERE DATA_MOV>='01.08.2024'
UPDATE  PT_MOVBEM SET DT_CONTABIL=DATA_MOV WHERE DATA_MOV BETWEEN '01.08.2024' AND '31.08.2024'
SELECT * FROM PT_MOVBEM WHERE DATA_MOV>='01.08.2024'
SELECT * FROM PT_CADPAT 
SELECT * FROM PT_CADPAT WHERE NOTA_PAT='23835484'
 UPDATE  TABEMPRESA SET TRAVA=NULL, TRAVADIARIO=NULL, TRAVAFINAL=NULL 
SELECT * FROM PT_MOVBEM WHERE CODIGO_PAT_MOV BETWEEN '1157' AND '1173'  
SELECT NOME, TRAVA, TRAVADIARIO, TRAVAFINAL FROM TABEMPRESA
select * from tabempresa 
select * from tabempresa where empresa=2 
SELECT * FROM VIEWLIQ 
SELECT * FROM VIEWLIQ WHERE CODIF_RESPATESTO=0
SELECT * FROM VIEWLIQ WHERE CODIF_RESPATESTO=0 AND DATAE >='01.12.2024'
UPDATE VIEWLIQ SET DTATESTO=DATAE, CODIF_RESPATESTO=1187 WHERE CODIF_RESPATESTO=0 AND DATAE >='01.12.2024'
select * from condia_tce where balco=35122020400
update condia_tce set FONCODIGO=500 where balco=35122020400 AND DATAE='30.12.2024'
select * from condia_tce where balco=35122020400
update condia_tce set FONCODIGO=500 where balco=35122020400 AND DATAE='30.12.2024'
select * from condia_tce where balco=35122020400
update condia_tce set FONCODIGO='500' where balco=35122020400 AND DATAE='30.12.2024'
select * from condia_tce where balco=35122020400
select * from despes where nempg=164
delete from despes where pkemp=252
select * from viewliq where pkemp=245
select * from dessub where pkemp=245
select * from cheqord 
select * from cheqord
select * from cheqord where ordpg=231