I have this code that is working perfectly, but I need random values to appear in place of X. I want the returned result to be composed of random letters and that the position of uppercase and lowercase letters be obeyed according to the user in...
I have the following insert
INSERT INTO tabela
(codigo, datahora )
(1, NVL('',TO_DATE('19/07/2017 19:49:00', 'DD/MM/YYYY HH24:MI:SS')))
Why NVL ?
Because if it has no valid value for date, it inserts an empty...
I'm in a project using PHP and Oracle. the connection is OK, with this code I can execute all the selects I normally need, which I can not execute are INSERTS , UPDATES and DELETE .
Could anyone tell me why?
I need help because I'm trying to run a windows service in Visual Studio 2015, but I can not continue because of the "The provider is not compatible with the version of Oracle client" error message.
I have devices . Each device, roughly, has its unique identifier, an IP address, and a type.
I have a pings routine for every device that has an ip address.
This routine is nothing more than a C # executable, whic...
I have the following query, used in an internal routine, for distribution of items for separation in data collectors:
Select distinct IP, USUARIO, DATA
Where pra.STATUS = 'OK'
AND trunc(pra.DATA) = trunc(sysdate...
I have a table that writes my records where one column writes the data_inicial and another column the data_final .
I need to generate a report where the user searches all the records that were between the period of eg 03/03/2017...
I have a Project with several Versions of applications that will be
developed, each Version several Requirement of New Functions
(NF), each NF with several Codes changes in various Repositories.
In addition, these NFs...
I have 2 projects (WebForms and Windows Services) in .NetFramework 4 that connects to the Oracle database through ObdcConnection.
In the web project I can successfully open the connection ...
However in Windows Services the following error...