Questions tagged as 'oracle'

Tagged questions
1
answer

sql oracle query to subtract two fields

Good, I've put the original querys that I'm going to use to give you an idea of the real problem, I need to subtract the values that return these two queries and do it all in the same query, that is, in the same query retrieve both values and th...
asked by 18.11.2016 / 19:23
1
answer

Error "SQLException: The flow has already been closed" when reading a field of type LONG

I make the following request from Java with JDBC to user_tab_columns : SELECT column_name, data_type, nullable, data_default, char_length, char_used FROM user_tab_columns WHERE table_name = 'mi_tabla' ORDER...
asked by 30.01.2017 / 17:43
2
answers

Look for char (13) or (10) in a field and replace it with a [closed] enter

Generate this variable that I bring from the database but in it there is char (13) or char (10) so what I want is to create a search engine where I find these two characters and convert it into another string so that it forms another my address...
asked by 18.11.2016 / 18:18
2
answers

consult 360,000 codes quickly java

I have 1 main Query whose response time is optimal, the problem arises when after executing my query inside the while I execute a second query that reads the code field and queries 1 by one, here my code: $_Query ="select * from remesas"; Resu...
asked by 30.11.2016 / 17:26
2
answers

sql query between 2 tables

I have the person table: id nombre sexo 1 paco 1 2 elena 2 3 alien null I have the table sex: id genero 1 hombre 2 mujer Starting from the bas that is a DB of the client that I can not touch, I make the following...
asked by 08.02.2017 / 12:10
2
answers

Use Update with INNER JOIN in Oracle

How about, I am running a scan in Oracle ( Update ) using INNER JOIN , but I could not do it. This is the code I am using: UPDATE A SET A.status = '2', target_date=SYSTIMESTAMP FROM Table_A A INNER JOIN TABLE_B B ON A.employee_number=B...
asked by 25.05.2016 / 22:19
1
answer

Query oracle group

I have the following tables: Students id nombre 1 Lucas Exams id fecha nota alumno_id 1 25/11/2018 5 1 2 26/11/2018 8 1 I need with a query, to extract the last note of the student according to his d...
asked by 26.11.2018 / 14:01
1
answer

What is the use of & gt and the & lt in a native query?

I have the following native query but I do not know what it means or what it does & gt, & lt <query> SELECT ID, ID_BASE, NOMBRE, RFC, NOMBRE_CLAVE, FEC_REGISTRO, FECH_PRINCIPAL FROM FACTURA F WHERE F.ID_BASE=?1 AND F.FEC_RE...
asked by 12.07.2018 / 05:35
2
answers

It is not sent to call java method, help!

Hello good morning to all, today I am trying a java method and the problem is that it is not sent to call, it is a hashMap this is the original code that was "hard code" and then changed dynamically by means of a SQL query within a method, this...
asked by 27.04.2018 / 18:36
2
answers

How to search with several columns in one table until finding the value in another table ?, ORACLE

Very good, someone knows how to perform a search between two tables, where the first has several columns and search with all those columns until finding a result in another table, I explain: Table1 | nombre | telefono1 | telefono2 | telefon...
asked by 28.02.2018 / 16:48