Posts by Vinícius Warken • 31 points
2 posts
-
0
votes1
answer28
viewsA: Create condition in instruction
If you are using PL-SQL in your script, you can solve it this way: DECLARE CURSOR C_CONSTRAINT IS SELECT CONSTRAINT_NAME FROM user_cons_columns WHERE COLUMN_NAME = 'CANCELAMENTO' AND table_name =…
-
2
votes2
answers247
viewsA: Update two tables with condition
For DBMS Oracle: UPDATE destino dest SET dest.nome = NVL((SELECT ori.nome FROM origem ori WHERE ori.cpf = dest.cpf), dest.nome);…