PL/SQL tutorial 13: PL/SQL FOR Loop In Oracle Database by Manish Sharma RebellionRider.com

Achei mais fácil o loop for, acrescentei refiz a aula da tabuada utilizando outro begin e for, coisas da minha cabeça kkk.

is indentation neccesary?

hi manish, what if we want to increment the counter by value 0f 2 each time ?

Bro these videos are so helpful, infact my teachers should get some classes from you and understand the concept of teaching first. Btw love you bro and bless you

Manish you just made my day ,thanks so much.

What does | | this mean plz explain I have exams tommorow 🙏

Love u manish❤️

‘ and ' have so much difference is plsql, why ?

Manish you are truly a great man. Thanks to you I got my first job!

Just incremented the likes to your video by one ^v^

Really helpful 👍

You are a hero without a cape Manish, thanks for sharing your tutorials.

Here it is automatically incrementing by 1.
What if i want to increment counter by 2 or some other value?
and yes buddy, you're helping me alot..
Love.

Bro, ending mei tum suddenly Farhan akhtar ban gaye lol.

Hi Manish , Your video is more knowledgeble. Pleas make videos of oracle performance tuning

Hello Manish...
I have a question..
If the loop counter in the for loop in pl/sql always incremented by 1 or decremented by 1..?
If I need to increment the loop counter by 2 or some more...then is this for loop suitable to do so??

thank you saved my practical marks for 2moros exam

begin
for b in 1..10 loop
dbms_output.put_line(b||'*19 ='||19 * b);
end loop;
end;

This could be more optimized, what do you think Manish? Is it a good practice to do it directly in print section?

the best u r !!!!!
Tqsm !!!

Thank you sir...

👍🏼👍🏼

whats up internet!

SET SERVEROUTPUT ON;
DECLARE
i number(6);
j number(11);
BEGIN
FOR j IN 1..11
LOOP
FOR i IN 1..6
LOOP
if(j>=7-i AND j<=5+i) then
DBMS_OUTPUT.PUT_LINE('*'||j);
else
DBMS_OUTPUT.PUT_LINE(' '||i);
END LOOP;
end loop;
end IF;
END;

How to print * pattern using for loop??

Great tutorials....short and perfectly precise.....

thanks ew :)

sir wat if decrement or increment more than 1

set serveroutput on;
declare
begin
for i in 1..10 loop
dbms_output.put_line(i ||' X ' ||' 19 ' || '= '|| i*19);
end loop;
end;

its very helpful ...thank you very much sir.....

Hi Manish ur videos are very informative and clear to understand
i request you to please upload reports and forms videos of oracle

Is there any example where you can show how to use functions in a loop, for example a date function in a loop that checks for correct date syntax

hi, manish, what if i wanna increment the counter by 2 or more dan 2 in for loop??? is there any soltn?

plz upload reports and forms in oracle

Thank you so much. your videos are very clear to understand. I need PLSQL CURSORS topics. so please provide that topics also.

your videos r really very clear, about the logic and also covers its other aspects.congrats for being such a great tutor to all of us.looking forward towards ur next videos.

thank u so much sir. it helps me a lot.

Hello sir,
i need SQL tutorial....start with basic.....

thanks dude.....awesome...gr8 job
i m waitig for ur next videoes

Hey Manish, I got a question, How can I insert 5 new arrows using loop and %TYPE?