Posts by beta_carlin • 1 point
3 posts
-
0
votes0
answers114
viewsQ: DBMS_OUTPUT.PUT_LINE command in oracle does not print anything and still the block is executed
I’m doing some exercises of fixing PL/SQL only that overnight the DBMS_OUTPUT.PUT_LINE stopped to print things in the SQL Developer console, and I have tried opening a new script or in several types…
-
0
votes1
answer121
viewsA: Anonymized block help with IF in PL/SQL
declare contador NUMBER := 0; contador2 NUMBER := 0; begin for REG in(Select * FROM EMPLOYEE)LOOP if REG.SEX = 'M' then contador := contador + 1; else contador2 := contador2 + 1; end if; end LOOP;…
pl-sqlanswered beta_carlin 1 -
-1
votes1
answer121
viewsQ: Anonymized block help with IF in PL/SQL
I am studying PL/SQL on my own account and I am having a lot of difficulty, I would like to tell you how I can improve the code below. I’m using the logic of wanting to pull and count every time the…
pl-sqlasked beta_carlin 1