Questions tagged as 'oracle'

Tagged questions
3
answers

How to verify if two data intervals have shared elements?

A few days ago I saw a question that among other things implied a problem similar to the one I am going to raise, I wanted to do it in a more general way, because I understand that the well-thought-out solution could serve as a reference to simi...
asked by 03.08.2017 / 04:55
1
answer

Execute subqueries in materialized view

Query. The following is a query that uses three tables: (Everything from here on is anonymous, some involuntary error can slip) SELECT id ,id_dependencia ,descripcion_corta NOMBRE ,to_char(fecha_fallecimiento, 'YYYY-MM-DD') FE...
asked by 29.06.2017 / 19:23
3
answers

Set default schema = ALGO in oracle using Spring Boot and Spring JDBC

I am now working with Oracle and Spring JDBC, but I do not want to use the schema in my sql statements: Example: Select * from SCHEMA.table Is there any way to set the default schema in application.properties or application.yml?...
asked by 22.06.2016 / 19:10
1
answer

Bring Query result (select * from ...) to XML

I wanted to know if there is a way in Oracle 10gR2, that the result of a query ( Select * from ... ) is stored in an XML. I want a stored procedure to have a single output parameter (XMLType), but the information in this parameter varie...
asked by 13.10.2016 / 01:18
2
answers

Insert records with select in insert

I am trying to insert records in a TB_DET_SUSCRIPCION_DOC table but the SELECT returns more than one record. the error is as follows.    Error Report: SQL Error: ORA-01427: single-row subquery returns   more than one row   01...
asked by 27.09.2016 / 22:31
1
answer

Help with PL / SQL insert in Oracle

What happens is that I am trying to do a search in two tables and through cursors with parameters do the calculation of a tax and insert the data in a new table called taxes. I have three tables, AUTOMOVIL , AVALUOS e IMPUESTOS...
asked by 04.10.2018 / 16:48
1
answer

Form String with single quote. Error ORA-01756

I am running a ORACLE statement from C++ and I receive this error:    ORA-01756: quoted string not properly terminated (OCI_ERROR) I form the string sentence as follows: sprintf(sentence, "INSERT INTO \"TABLA\".\"...
asked by 11.11.2016 / 09:37
2
answers

Update several tables at the same time Oracle

I try to update three tables in Oracle, which are totally different, but in all there is a field exactly the same "STATUS". The issue is that I need these fields to be updated to "NEW". This is why I have asked myself if it is possible to...
asked by 08.05.2017 / 22:12
2
answers

What does the use of (+) mean in an Oracle query? [duplicate]

I would like to know the use of the operator (+) in the following query and what is its possible equivalence in MySQL. SELECT 'E' tipo_envase, DECODE(NVL(pasi_parametro1,'-'),'-','CRE','CON') tipo_pago, vaca_serie, vaca_numero, vaca_l...
asked by 04.10.2016 / 00:05
1
answer

Error when wanting to update table in oracle 10g: "ORA-00054: resource busy and acquire with NOWAIT specified"

I have a small problem with my database. We connected several users, a moment ago I was working on it, but I was offline. Just when I gave it a commit, when updating a record, then I logged in again, but there was no update to my record. Then I...
asked by 27.04.2017 / 01:28