Questions tagged as 'oracle'

Tagged questions
1
answer

Error comparing dates ORA-00932

I'm having a problem comparing 2 dates in oracle. I am using the case method to compare the dates and at the end this should return to my table a number, which in the case represents an age, however, I get p error reporting: PL / SQL: ORA-009...
asked by 21.07.2014 / 14:43
1
answer

Does anyone know how to connect oracle in codeigniter? [closed]

I can not connect to codeigniter in oracle. Displays this error: A PHP Error was encountered Severity: Notice Message: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' Filename: database/DB.php Line N...
asked by 20.02.2014 / 00:39
3
answers

Viewing Oracle database data via MySQL

I need to know how do I get the data from an Oracle database in my MySQL database, a kind of view . I do not want to do insert , update nor delete in the Oracle database, I only need%% of this data to have them in my MySQ...
asked by 18.12.2014 / 16:52
1
answer

Oracle Relationship Query Query

I have a program to look for records dependencies to proceed with deletion of data here in the company. We support some banks but in Oracle the query is processed very slowly (about 10 to 15 seconds for each table in remote production ban...
asked by 04.06.2014 / 14:18
2
answers

Why does To_char (3E4) not result in '3E4'?

How do I convert an exponential number (NUMBER) to string (VARCHAR) but which is expressed equal to? Example: SQL> SELECT TO_CHAR (NUMERO) NUMCONVERT 2 FROM (SELECT 3E4 NUMERO FROM DUAL); NUMCONVERT --------------------------...
asked by 13.04.2017 / 18:37
3
answers

Group date periods

I need to do a query that returns all records grouped in certain periods. The table contains a date type and should produce output similar to this: | Hora | Quantidade | ------------------------- 01 | 08:00 | 30 | 02 | 08:05 | 28...
asked by 10.11.2016 / 13:38
1
answer

Application stopping when there are many users accessing

My application is crashing and I do not know exactly why. The only thing I notice is that when there are many users accessing, or making requests this happens. When it happens, I have to restart the application pool and lift the application a...
asked by 16.03.2016 / 15:04
1
answer

SQL script, to insert emails into a table, and then change them

I have a script, which makes random insertions of emails into a table, after these inserts, I need to find a way to recheck those inserted emails, and change them This is a part of Script, I give him a lot of emails (for example 5), and he wi...
asked by 12.06.2018 / 15:02
1
answer

Select max in nested queries

I have to select the candidate who has more publications than any of the other candidates. select candidato.nome, Count(1) as nr_publicacoes from candidato, cv,ficha_inscricao, publicacao_cv where candidato.bi = ficha_inscricao.bi and...
asked by 20.11.2015 / 10:06
1
answer

How to do an autocomplete with ajax?

I'm trying to implement an autocomplete with ajax, where I search the database and show the options in the input, but I can not identify where I am wrong. Follow the code: <div class="row troca"> <div class="s...
asked by 13.04.2015 / 20:06