I have four searches to do, but instead of doing it separately I would like to make just one in a row. Could someone help me please? Here is the following querys:
Number1
select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM srf_operacoes WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')
Number 2
select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM ativos WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')
Number 3
select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM srf_base WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')
Number 4
select ATIVO,'' VENCIMENTO, QUANTIDADE ,PRECO,'' CODFAR,'' FINANCEIRO,'','','','',CLASSIFICACAO FROM ativos_rf WHERE data = to_date ('14/06/2016', 'dd/mm/yyyy')
Aucun commentaire:
Enregistrer un commentaire