Questions tagged as 'oracle'

Tagged questions
1
answer

remove product from product table that is related to sales note

Hi, I'm a newbie in web programming and I just finished my first website in my professional practice and the company was satisfied, only my question is for example I have my BD which has a table related to a table. sale, the doubt in particular...
asked by 31.05.2018 / 05:47
1
answer

query in table in BD oracle with internal clauses

HELLO,  I want to make a query in ORACLE that brings me all the scores that are lower than 3.0 (YELLOW) but not of those that have the same DERA_FKREGISTROACTIVIDAD and in some have a score higher than 3.0, the blues have a score less than...
asked by 30.05.2018 / 23:14
0
answers

Problem with dates vb6 and oracle

I have a report application developed in VB6 and Oracle 8 database. For needs that were arising, I was putting new fields and functions that complicated the query. The last one is that it was necessary to list by production date, being between 7...
asked by 01.06.2018 / 15:52
1
answer

How to scan vulnerabilities in Oracle database connected to desktop application?

I am using the Kali-Linux distribution for security audits that I am doing in my project, in web applications if I have been able to audit well, but now the case:  I have a desktop application for Windows that connects to an Oracle DB, however,...
asked by 20.06.2018 / 15:32
0
answers

TRIGGER SQL ORACLE

Someone knows how I can make a trigger that at the moment of connecting to the database, check if the user system is connected at that moment. In the affirmative case, an error should be thrown and the user should not be connected.     
asked by 20.05.2018 / 21:07
0
answers

Is it possible to have a strong entity that encompasses several entities in database modeling?

I am in doubt about the database modeling I mention the case: I have a database with some of the tables that are PERSONA (nro_documento,apellidos,nombres,fnacimiento,id_genero,id_tdocumento) TRABAJADOR (nro_documento,codtrabajador,sueldo,id_de...
asked by 18.05.2018 / 13:23
1
answer

How to send an alert from BD Oracle to Java web

I come with a question that has given me a couple of laps .... I have a Java web app that, among many things, maintains the stock of products, the Oracle database has the table (image) where the data persists. So my query is: Can I use a...
asked by 17.05.2018 / 05:16
0
answers

Upload Oracle database to a host

I commented to you, I have an oracle database in a virtual machine that is connected to a web page. (All in localhost) I would like to know if there is any hosting (free) where I can upload the oracle database, or if there is any way to uploa...
asked by 13.05.2018 / 21:23
1
answer

error when compiling a stored procedure in oracle

Dear good evening. I request your help with the following script CREATE OR REPLACE PACKAGE pkg_ingresar_cliente AS CURSOR cur_id_cli IS SELECT id_cliente FROM registro_cliente ORDER BY id_cliente DESC; PROCEDURE prc_...
asked by 09.05.2018 / 04:16
0
answers

how to get the value of a stored procedure

I have a question I am using stored procedures with oracle and take them to a web page in asp the question is that I have this stored procedure from which I get the login and password of the database. But I also want to bring a description th...
asked by 09.05.2018 / 18:45