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:...
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
(...
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...
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...
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
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...
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...
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...
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...