Questions tagged as 'oracle'

Tagged questions
0
answers

Oracle - Error inserting a row - index marked FAILED

Good morning! When trying to insert a line in the database, it gives the error:    The domain index is marked LOADING / FAILED / UNUSABLE This index marked as failure has the name: "ROLO_IDX" When trying to rebuild the other error:...
asked by 08.06.2018 / 15:16
0
answers

How to create a total column in PIVOT

I have the following column RA COD_CADASTRO COD_TURMA SEMESTRE SITUACAO ---------- --------------------------------------- ---------- ---------- --------------- 917606337...
asked by 09.06.2018 / 17:47
1
answer

Oracle - How to generate every day (Calendar) between two Dates with different Years [duplicate]

How to generate the interval of all days of the months between two dates? Considering only the parameters: Start Date: 10/01/2014 Final Date: 12/29/2018 Example: 01/01/2014 02/01/2014 03/01/2014 ... 12/26/2018 12/27/2018 12/28/...
asked by 06.06.2018 / 03:03
0
answers

Failed to install Oracle OCI8!

Hello, I followed several tutorials and did all steps correctly, and I can not install Oracle OCI8 , now after several attempts I get this message: php -v PHP Warning: PHP Startup: Unable to load dynamic library 'oci8.so' (tried: /usr/l...
asked by 08.06.2018 / 16:35
0
answers

What is 'read consistency' in database?

I'm doing an article about Oracle DBMS. And when version 4 was released, it was the first database to have read consistency . However, I can not find what this is or what the meaning of this functionality is for the context of the time, or even...
asked by 27.05.2018 / 00:24
1
answer

Subselect OrderBy first line

I'm doing the select below but in the last subselect (mileage) I'm having problems with the ORDER BY error "ORA-00907: missing right parenthesis", if I remove ORDER BY it works. SELECT /* DATE OF THE ROUTE */ {GPS}.[DateTi...
asked by 24.05.2018 / 11:16
0
answers

Doubt with 'OracleDataReader' is defined in an assembly that is not referenced

I'm using the Oracle.ManagedDataAccess.Client, it is referenced to the project containing the context. I have my Context: namespace Generico.Repositorio { public class Contexto : IDisposable { private readonly OracleConnecti...
asked by 29.05.2018 / 21:34
2
answers

Bring the second and third line of a query

Oracle-SQL I have a table that records the point records that each employee does. The table gives the following information: (TABELA QUE ESTOU FAZENDO A CONSULTA) Contrato | Data | Hora 1 | 10/05/2018 | 07:00 1 | 10/...
asked by 25.05.2018 / 00:13
0
answers

Oracle 10g decompiled scripts

.NET Dll is used to compile scripts, but in Oracle 10g databases the scripts are decompiled and you need to perform the compilation using a SQL Developer , for example. Reported that this occurs only for Oracle 10g. Why does this o...
asked by 22.05.2018 / 20:44
0
answers

Oracle Package SMTP, validate domain

I want to know how I can: validate domain using Oracle Package SMTP; Can I validate a domain or even an email without having to send a email ? I want to use an action close to "ping" to answer the question. Thank y...
asked by 11.05.2018 / 20:49