Posts by CARLOS DANIEL • 13 points
5 posts
-
0
votes0
answers28
viewsQ: Trigger with mutant error even using Pragma Autonomous_transaction;
I’m a beginner and I’m having trouble solving a simple problem: I created Trigger below: AFTER INSERT OR UPDATE ON CARRO FOR EACH ROW DECLARE Pragma Autonomous_Transaction; V_REFERENCIA INT; BEGIN…
-
0
votes1
answer43
viewsQ: the identifier 'DMBS_OUTPUT.CHARARR' must be declared plsql oracle
I am writing the following plsql code: declare tab dmbs_output.chararr; qtlines number default 3; res varchar2(100) default null; begin dbms_output.get_lines(tab, qtlines); dbms_output.put_line(…
-
1
votes1
answer43
viewsQ: Time mask HH:MM from a number type field using oracle sql for reporting
I have a query that I use to report hours worked, I tried to use to_char and some other examples I found in stackoverflow. SELECT CASE WHEN BC.ENTRADA1 IS NULL THEN 0 ELSE…
-
0
votes1
answer24
viewsQ: Error in the subselect of an sql script to generate update script bringing more than one line and giving errors
I have two tables, a partner of which some fields of cnpj_cpf are wrong and another that I went up with the corrected data, totaling I have approximately 1 million lines to solve, so I generated a…
-
0
votes1
answer387
viewsQ: Counter does not update data on the page using Reactjs and useState(), only when I place a console.log() can I see the result
I’m taking a Reactjs course, and I’m trying to follow all the code examples, but my code is the same as the instructor’s and yet mine is not working the same as his. Every time you click increment,…