Posts by Lucas Martins • 1 point
3 posts
-
0
votes0
answers35
viewsQ: PROCEDURE ignoring update - PL-SQL
I made the following code: CREATE OR replace noneditionable PROCEDURE comissao IS BEGIN FOR v_linha IN ( SELECT p.codvendedor AS codvend, p.comissao AS comissao, SUM(f.valortotal) AS quant FROM…
-
0
votes1
answer118
viewsA: Problem in the condition of Trigger - PL-SQL
Teacher’s answer: The only problem that exists in its code is in the use of double quotes in RAISE_APPLICATION_ERROR. Instead of being like this: RAISE_APPLICATION_ERROR(-20010,'"The quantity of the…
-
0
votes1
answer118
viewsQ: Problem in the condition of Trigger - PL-SQL
My teacher passed that question: Write a Rigger that checks, during registration/change of a sale, the following: 1) The QUANTITY field of the ITEMVENDA table shall not have decimal places and shall…