I need to make a stored procedure that reads an XML file and writes to a table in my bank, but I have no idea how to do this ...
Can anyone help me?
I have 2 hours to deliver this.
I'm having trouble returning my ID using nextval, and then inserting it into my table
OleDbConnection cnx = new OleDbConnection(new AdministradorDAO().conexao);
cnx.Open();
string seq = ("select id_usuarios.nextval from dual");...
I have a table named Teste de aluno and a call Parametros
I need to create a Query that compares if the test conforms to the Parameters
The problem is that the tables are not 100% similar
Test Table:
IDTESTE
PARAMETRO1
PARA...
Well, due to the exhaustion of my attempts to find the error, I will try to get a light here with you. Of course I apologize if the error is too generic and does not have the necessary infos.
But here goes a part of the scenario and the situa...
How do I get all rows using IN (), and inside the IN () have duplicate values
SELECT NOME FROM PESSOA WHERE ID IN (1,1,1,2,3,3,4)
I want to return 3 times the name of ID 1, and 2 times the name of ID 3.
We have an Oracle 11G here in the company. Last week some funny guy tried to login more than 10 times with incorrect user or passwords.
I researched and I'm looking for some way to save access logs in the database, like the IP of the machine you...
How to create a Function or Procedure that calls another Procedure to perform a neighborhood change in my ERP system?
Follow the procedure below I want to set values for the parameters of it. It should be called based on a neighborhood table...
In the query below you are bringing it that way.
Data Inicial Data Final Dia da Semana
16/10/18 30/10/2018 3
Where this start date and end date is for a specific time period, and the day of the week in that cas...
In the query below you are leaving this way.
Unidade Ordem_Compra CNPJ Aprovador
Sim Boavista 29021 155454878787 Ivan
Sim Boavista 29021 155454878787 Romel
The question is: How do I leave o...
In the query below in column Valor_Total_da_Ordem it is giving a totally different value, much higher than it actually was to be. The value is giving 55990,62. Being that the correct value is to be 1333.11.
What could have happened?...