Questions tagged as 'oracle'

2
answers

Method that uses a random value as a parameter to change the characters of a string

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...
asked by 20.10.2017 / 17:36
1
answer

Insert DATE TIME in Oracle

I have the following insert INSERT INTO tabela (codigo, datahora ) VALUES (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...
asked by 20.07.2017 / 01:56
1
answer

ODBC PHP / Oracle - UPDATE, INSERT, DELETE

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? <?php requ...
asked by 20.12.2016 / 17:19
1
answer

The provider is not compatible with the version of Oracle client [closed]

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. Thank you.     
asked by 11.10.2016 / 15:34
1
answer

Best way to structure history table with large amount of data

Functional requirement 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...
asked by 24.05.2016 / 16:26
1
answer

Query with random result

I have the following query, used in an internal routine, for distribution of items for separation in data collectors: Select distinct IP, USUARIO, DATA from PCN_ROMANEIO_ACESSO PRA Where pra.STATUS = 'OK' AND trunc(pra.DATA) = trunc(sysdate...
asked by 24.10.2016 / 13:12
1
answer

SQL / ORACLE Filter active records in month

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...
asked by 10.04.2017 / 19:41
1
answer

Date in odd fractional form 0.00xxxxxxx

I get this date from DB:    0.002976190476190476 I would like to pass this format: dd/mm/yyyy , using javascript pure or jquery . How do I do it? Here is the ASP that mounts the select: strsql = ""...
asked by 04.01.2016 / 18:01
1
answer

Conversion and grouping of rows in columns dynamically in Oracle

Context:    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...
asked by 18.12.2015 / 21:08
1
answer

Windows Service - ERROR [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified

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...
asked by 29.08.2014 / 00:11