Questions tagged as 'oracle'

Tagged questions
1
answer

How to join these 2 ORACLE queries?

I am implementing 2 queries which have very common in contrast to one that makes a filter First query: SELECT FECHA, sum( case org_account when 'OtaDMC' then...
asked by 12.12.2018 / 16:31
1
answer

ORACLE Optimize queries with not exists and dblink

With the not exists it takes 1 min. SELECT PED.NFCH "NFCH", PED.NFCHF "NFCHF", PED.CNL "CNL", PED.CLI "CLI", PED.GRC "GRC" FROM PE@DBV PED WHERE PED.NFCH = 2016...
asked by 02.02.2016 / 15:25
1
answer

ORA-02253: constraint specification not allowed here

Hello, I have this table created in oracle : CREATE TABLE SUBCONTRACT( CIF CHAR(9) NOT NULL CONSTRAINT PK_SUBCONTRACTS_CIF primary key, NAME VARCHAR2(50) NOT NULL, ADDRESSSTREET varchar2(50) not null, ADDRESSNUM number(7,0) not null, ADDRESS...
asked by 30.11.2018 / 23:49
1
answer

IF nested PL / SQL

Good Morning People; I ask for the collaboration of the community because I can not explain why the second if it is nested is not being evaluated, is not being evaluated and enters if the structure is true or false example (1 = 2) and enters? .....
asked by 23.03.2016 / 14:30
1
answer

You doubt about trigger to update a field in the same table that triggers it

I have created a trigger that triggers when I modify the value of a record of a table, in this case the number of components that I have in the company. That is, the trigger only allows me to modify this amount if the new value is...
asked by 17.11.2018 / 11:21
1
answer

traverse 12 csv files with UTL_FILE

Friends, this is the code I'm doing to go through 12 CSV files, but you're only reading the last file, you can help me PROCEDURE SP_CARGA_POLY_EXTERNA (V_ERROR OUT VARCHAR2, V_MENSAJE_ERROR OUT VARCHAR2) IS V_SECUENCIA NUMBER :=1;...
asked by 31.10.2018 / 22:16
0
answers

help, Create DAO with inherited classes

I am doing a project in which the class has the following structure package Model; public class ClProducto {     private int id;     private String name;     private String descriptionHTML;     private ClUnity Measured unit MeasuredId;     pr...
asked by 07.10.2018 / 05:56
0
answers

Help with putting together a query in Oracle?

I have a table called ESTRUCTURA that has the fields ID_ESTRUCTURA, NOMBRE_TRABAJADOR, ACTIVO And a table called TRABAJADOR_RANGO that has the fields ID_TRABAJADOR_RANGO, ID_ESTRUCTURA, ID_SERVICIO, TIPO_RANGO What I want...
asked by 05.10.2018 / 05:57
1
answer

How can I solve this type of error when testing?

When executing in the console it happens that a "next" error that is hosted in the "while" bounce    java.sql.SQLException: Unable to perform recovery on a   PLSQL statement: next at   oracle.jdbc.driver.OracleResultSetImpl.next (OracleResult...
asked by 29.08.2018 / 07:13
3
answers

I must consult a field in a table and see if there is a value

In a table I have the CM1_CUENTA field where a user can have many accounts but I need to know if among all of them exists the numbers 2365xxxx or 53152001 to perform an action and if none exists, perform another action. consulta2 = "SELECT * F...
asked by 10.08.2018 / 22:39