Questions tagged as 'oracle'

Tagged questions
0
answers

Duplicate a tuple by changing a field

Very good. I have a table called ALBARAN_SALES in which I must do a replica of a tuple as the following exercise asks:    REPLICATE_ALBARAN. Generate the replication of a sales slip   (including lines). The delivery note to be replicated will...
asked by 29.09.2018 / 00:41
0
answers

Oracle Forms - Jasper Reports

I have several important questions, I would like to know if there is any way to call Jasper reports located in the Jasper Server by means of a form Oracle, there is some kind of integration as such, I would like to know if there are examples of...
asked by 25.09.2018 / 22:37
2
answers

Problems when creating SP in Oracle

Good morning, I have a problem creating a stored procedure in Oracle and trying to save it tells me that I do not have privileges for the table to which I refer, but if I create the SP if I run the slect directly if it brings me re...
asked by 20.09.2018 / 01:11
1
answer

Read an XMLtype with pl / sql

I have a function that receives an xml parameter, I need to keep only one part, and return that "new xml". I understand it is done with the Extract function but it would not be working for me. I get error: ORA-00932 incosistent datatypes: expect...
asked by 18.09.2018 / 14:06
0
answers

How to save a trigger of a table A in scheme A in another table B of scheme B?

I need to save some data in a Bitacora table when I update the Salary attribute, the detail is that the Bitacora table is in a DA user and the Salary attribute belongs to the Employee table which is in the AD user, then I show the trigger that I...
asked by 15.09.2018 / 02:53
1
answer

I need to know the last record of an oracle table

please your support I need to know the last record in the table carga_diaria_sp taking as input eje_ejecucion? select a.telefono, b.origen as "LEGADO", (Select CASE WHEN CNOMBRE_ARCH = 'NULL' THEN CDESCRIPCION ELSE...
asked by 19.09.2018 / 19:42
1
answer

Error when placing a WHEN in SQL query - ORACLE

I have a query in oracle: WITH hist_snaps AS (SELECT instance_number, snap_id, round(begin_interval_time,'MI') datetime, ( begin_interval_time + 0 - LAG (begin_interval_time + 0) OVE...
asked by 12.09.2018 / 18:47
0
answers

How can I connect my database in Oracle with Codeblocks?

Good morning friends, I have the following problem: I'm doing a job for the university (a game in itself) but I need to connect the information collected in a database. Something like classic games that show markers and names. But I have prob...
asked by 03.09.2018 / 21:40
0
answers

Programmed refresh of views materialized in Oracle

I'm trying to refresh a view with REFRESH FORCE ON DEMAND to perform a refresh in the next time window: Every day from 08:00 to 23:59, with a period of 4 hours between refreshments. I'm using REFRESH FORCE ON DEMAND START WITH sysdate+0 NE...
asked by 04.09.2018 / 09:05
1
answer

I have a sequence in ORACLE that adds 1 to a row, as I show the current value when I open the APP

I need to show where the account is going so that when printing is shown and with this code sumo 1 to the consecutive // contar 1 al consecutivo cuando imprima var oracleConnectionStringBuilder = new OracleConnectionStringBuilder...
asked by 17.08.2018 / 23:40