Questions tagged as 'oracle'

Tagged questions
0
answers

Backup in oracle db using triggers

I have 2 identical tables, just change the name table1 and table2 , when you enter 3 records in table1 the information in this table must be copied to table 2 and table 1 must be empty again.    The solution must be reached using tri...
asked by 25.07.2018 / 22:09
0
answers

My trigger compiles but does not work [closed]

I have a problem with the trigger to reduce stock. The trigger compiles me and everything but how much I insert data into my table detalle_venta, in the product table it does not reduce the amount. These are my tables: create table producto...
asked by 18.07.2018 / 06:03
0
answers

Query for data counting, using median () SQL Oracle

This query is for a graph, I take the count () of the records that are greater, equal or less than a certain amount, but the field of Media, I need to be dynamic, that is to say that each time the query is made perform, calculate the average of...
asked by 03.07.2018 / 21:09
2
answers

Problem with LOOP PL / SQL, Oracle [closed]

I am currently working on a query with PL / SQL which I have not been able to do, the idea of this query is to be able to traverse (or compare) the rows of a table given the upper and lower limits of the table, that is, for example: there is a t...
asked by 09.08.2018 / 17:54
0
answers

Error with trigger with IF and UPDATE in ORACLE

executing this trigger in ORACLE I got the following error: Table,View Or Sequence reference 'OCEX_COMI.FECHA_ASIG_GT' not allowed in this context. This is my trigger: create or replace trigger ocex_comi_total before insert or update...
asked by 29.06.2018 / 02:46
1
answer

View the tables of an Oracle user

I'm working on a database in SQL Developer, create a user named Nagato2 and with it create a connection called test2, in which I put all my tables. However, I was asked to create a new user within this connection that I called Nagato3....
asked by 12.05.2018 / 01:52
1
answer

Add the value of each period and put 0 in the periods that do not exist in SQL Query table

I have two Income and Periods tables, within the Periods table are the months from January to February and in Income I have a value_port column in which there are records for what has been contributed in each month. ex. Ingresos Periodo Valor_...
asked by 06.04.2018 / 23:02
1
answer

C # insert data null

You could support me I'm new, I'm migrating data from Oracle to SQL server but the problem is that I'm trying to insert data and everything was fine, until I came up with the following: When inserting the data there are null fields and I do not...
asked by 15.04.2018 / 09:46
2
answers

python to oracle connection

Someone will know how to make the python to oracle connection and try to do it with    import cx_Oracle but I got the following error    cx_Oracle.DatabaseError: DPI-1047: 32-bit Oracle Client library can not   be loaded: "The specifie...
asked by 27.03.2018 / 02:14
0
answers

Read a database with Entity Framework with Read Only permissions?

I'm doing a webservice using a WCF project and EF6 Code First and DB Firts, however the permissions that I have on an Oracle database are read only, is there any way to process that DB with entity? to know the restrictions of each column of a ta...
asked by 09.03.2018 / 23:22