Questions tagged as 'oracle12c'

1
answer

Select with specific column - Oracle

I've been migrating to Oracle and found a question. In SQL Server I could do this: select coluna, * from tabela How do I get a similar result using Oracle 12c?     
asked by 11.06.2018 / 15:45
0
answers

Oracle PL / SQL - Connection with Webserver SEFAZ

Has anyone here been able to establish and authenticate SEFAZ (NF-e or Reinf) servers via PL / SQL with Oracle Wallet? For the last few weeks I have been trying to establish contact with these webservers, first with Oracle 11, and then with O...
asked by 01.08.2017 / 14:47
0
answers

Insert with result of a select, how can I do this in Oracle?

Can anyone tell me how I can write to the Oracle database with Loop. When I run below it only writes the first record. INSERT INTO BURD_400 ( NIVEL, GRUPO ... ) SELECT BURD_ESTQ_300_MOVIMENTO_60D.NIVEL_ESTRUTURA,...
asked by 01.10.2018 / 22:50
1
answer

not in the same table

Let's say I have the CON_CONTRATOS table and I have con_customerId , con_vencimento among others. And I need to do a select that returns me ALL the contracts of a customer whose contract is only with con_vencimento not nul...
asked by 05.10.2018 / 13:07
1
answer

Error inserting data into recordset with provider oraOLEDB

Good afternoon guys. I have a problem with several applications here in the company that are in VB6 . When I try to include a record in a recordset an error occurs (it is described in the code), however it only happens when I use provi...
asked by 19.09.2018 / 22:29
0
answers

Error in VB6 application using the provider oraOLEDB.oracle

Good morning. In the company where we work we have several applications in VB6 and after 2 clients upgrade to Oracle 12.2 that uses the oraOLEDB.oracle provider instead of MSDAORA the applications started to present several errors. Example...
asked by 23.08.2018 / 16:58
0
answers

Remove unnecessary fields in the RESTful Management API from WebLogic

I'm developing a service for monitoring applications deployed on WebLogic servers and for that I'm using your REST API to query the information and perform the operations I need. By using the GET /management/wls/12.1.3.0/deployments/applic...
asked by 04.04.2018 / 17:11
0
answers

Error in connection to oracle database after it does publish in azure with visual studio

I'm developing a project in asp.net with Oracle data base 12c. The connection to the database, locally, works. It does all the CRUD functions. I am also using azure services (project requirement) for both the bank and the website. When I publish...
asked by 12.03.2018 / 20:25