Posts by R. Genaro • 36 points
3 posts
-
1
votes1
answer844
viewsA: Why does this query not work on Oracle?
The problem is in your subquery (QTD_UM). The table of alias ITM cannot be used in Join condition at that point. For correction, simply put the Join conditions that use the main query columns in the…
-
1
votes3
answers928
viewsA: Update in a field that cannot be negative
You could use an analytical function to identify the records that will need to be updated, the function greatest to prevent a certain value from being negative, and the command merge ( or a simple…
-
0
votes2
answers265
viewsA: No update of a Collection PL/SQL
The fetch was performed in the variable linhaRegCompara, whereas p_doc (used in the clause where of update) has never been initialized, with the value null. With this, the condition is never…