Questions tagged as 'pl-sql'

1
answer

ORA-01799: a column may not be over-joined to a subquery

I am having a problem with oracle, it is not accepting a subquery in a left join, if I change to inner join it works, but it changes the result of my select then does not answer the solution. the problem happens with the following example:...
asked by 15.04.2016 / 15:59
1
answer

Bitand in the where clause

I need to do the following Query, but it is generating some syntax or logic errors. SELECT campo_X, campo_Y FROM tabela_Z WHERE( ( BITAND(1, 1) > 0 AND campo_A NOT IN (2,4,8,9) ) OR (...
asked by 21.01.2015 / 14:25
1
answer

SQL - IN within a SUB SELECT with NOT IN - ORACLE

I wanted to make my INSERT dynamic, which does not require me to change the ids manually. I have this script that returns all PRODUCTS that do not have a relationship with the table EST_PROD_PRECO_CUSTO_EMPRESA SELECT prod.ID_PRODUTO AS "ID...
asked by 12.09.2018 / 20:46
0
answers

PLSQL update a node in xmltype

I have to update a column in xmltype format of an Oracle database. I basically only update of property valor if another property of this node the date and time are equal. That is, in the code below, I only do update...
asked by 20.08.2018 / 14:04
1
answer

How to display SQL History in SQL Developer?

I need to view all of the alters in a procedure. The SQL Developer tool has a toolbar that stores a history of changes. How can I enable / view? Image of the functionality     
asked by 30.01.2018 / 14:29
0
answers

SQL script monitoring [closed]

Someone can help me, In my company I have a script that verifies how many emails were processed and sent by the server, but sometimes the program that makes the uploads hangs and I only know that it has blocked why my users complain that ther...
asked by 10.01.2018 / 11:54
0
answers

PL / SQL - Trigger: Can I see the entire row updated in a row after trigger?

I am studying PL / SQL in college and the teacher has passed some questions based on Oracle's own Human Resources model. The question I am asking asks for a trigger that prevents an employee from having a salary greater than his boss. And for th...
asked by 12.11.2017 / 07:15
2
answers

Difficulty with Select

I want to make a query of 1 table that has the records: Predio | Local | Produto | FIFO P01 | WH01 | Maçã | 21/02/17 P01 | WH01 | Maçã | 22/02/17 P01 | WH01 | Maçã | 23/02/17 P01 | WH01 | Maçã | 28/02/17 P...
asked by 04.12.2017 / 20:42
1
answer

Update in PL / SQL

Given two tables, product and order tables, I'm trying to update the product description of the products table when the product status is 'INATIVE' and the status of the orders table is 'CLOSED' create table PEDIDOS ( CLIENTE_ID NUMBER not n...
asked by 03.11.2017 / 20:08
2
answers

order by in oracle subquerys

RESOLVED I decided to create a view equal to my work order table plus it was ordered by the team and the priority, and I kept the above query by changing only the table of the subquery that I placed the view I created, so I do not have to wor...
asked by 23.08.2017 / 15:04