Questions tagged as 'oracle'

Tagged questions
1
answer

Trigger to avoid duplication of data in ORACLE

I'm learning Oracle and I had a problem. I have my Chat table: create table Charla ( id_charla number, codigo_usuario number, fecha_charla date, fecha_fincharla date ) Now, create a trigger so that it does not allow me to enter...
asked by 02.08.2018 / 00:03
1
answer

Problems with a trigger in ORACLE

I'm learning ORACLE and I create a trigger that after each insertion in the Commission table is added in the Pago_Com column from the table UEA em> which in turn is related to the table Guia_Transito and when I try to insert in the table...
asked by 25.06.2018 / 04:47
1
answer

Error Trigger AFTER DELETE

I have the following code: create or replace trigger calckmdl after delete on tsegmento for each row declare total rutas.km%type; begin if deleting then select km into total from rutas where ruta=:new.ruta; if :old.unidad = 'km...
asked by 26.06.2018 / 02:30
1
answer

Problems showing images [duplicate]

I have this code that prints images from the server, but I can only see it on the server and on the internet explorer only: <img src='file://192.168.10.129/sapshared/FOTOS/KennedyDB/$row[PicturName]' height = '100' width = '100' &g...
asked by 09.05.2018 / 04:09
1
answer

How to enter a sql query in java, replacing hard code of a map?

I hope and they are well, I have a problem, what I need is to replace the hard code of a java map, for the results that an sql query returns to me, the hard code is this: { this.correspondencia=new HashMap<String, String>();...
asked by 26.04.2018 / 16:55
1
answer

Oracle Sql XE - Error entering sqlplus [Linux deepin (based on debian)]

I have a problem trying to login to sqlplus from the terminal. I run the sqlplus command, and then it asks for username and password. When trying to put system and the password that I put during the installation, I find the following error...
asked by 29.04.2018 / 02:23
1
answer

Inner Join Sub consultation

I am making a query which should return the client's code, name, years and the quantity sold. When I do not perform the filter (which shows me repeated results) I have no problem this is the query: select c.codigo_cliente, c.nombre, (to_number...
asked by 04.05.2018 / 09:03
1
answer

Get access to oracle

Who understands Oracle ... Are there ways to recover the database password? We have a system that works with Oracle but now we have decided to change the system and we do not have access to the database because the one that made the system did n...
asked by 14.04.2018 / 16:23
1
answer

Error between java - jdbc oralce, resultset null

Currently I have a code that executes a query to a database in oracle which returns about 200,000 results and then I run the resultset to build a csv. The problem I have is that sometimes, some values of a column of the resultset reach nul...
asked by 09.04.2018 / 17:28
2
answers

Exercise in PL / SQL

Encode a procedure that receives as parameters a department number, an amount and a percentage and that raises the salary to all the employees of the department indicated in the call. The increase will be the percentage or amount indicated in th...
asked by 07.04.2018 / 19:42