Posts by Ewerton Gomes • 11 points
3 posts
-
0
votes0
answers80
viewsQ: PLSQL - Nextval fault
The following code: Create a Trigger that creates a log record every time a product is changed. CREATE OR REPLACE TRIGGER CREATE_LOG AFTER UPDATE OR INSERT ON PRODUTO FOR EACH ROW BEGIN INSERT INTO…
-
0
votes4
answers68
viewsA: Doubt about Group by
Ola managed to solve as follows select client.name, sum(itempedido.quantity) "Total purchase" from itempedido Inner Join request on request.idrequest = itemped.idrequest Inner Join client on…
-
0
votes4
answers68
viewsQ: Doubt about Group by
using SQL Server I have made the following select to select products purchased by customers: select ITEMPEDIDO.IDPEDIDO, ITEMPEDIDO.QUANTIDADE, CLIENTE.NOME from ITEMPEDIDO, cliente, pedido where…