PL/SQL Tutorial #12: Loops, Type of Loops and Simple Loop in PLSQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ก.พ. 2025
  • we are focusing on how to use Loops in PLSQL and types of loops with appropriate examples.
    it very helpful to all the students and beginners as well. so keep going with oracle shooter.
    Related Topic:-
    PL/SQL Tutorial #1: Introduction of PLSQL
    :- • PL/SQL Tutorial #1: In...
    PL/SQL Tutorial #2: Anonymous Block in PLSQL
    :- • PL/SQL Tutorial #2: An...
    PL/SQL Tutorial #3: Structure of PLSQL Block OR Named block in PLSQL
    :- • PL/SQL Tutorial #3: St...
    PL/SQL Tutorial #4: What are variables in PLSQL
    :- • PL/SQL Tutorial #4: Wh...
    PL/SQL Tutorial #5: Concept of Bind variables in PLSQL
    :- • PL/SQL Tutorial #5: Co...
    PL/SQL Tutorial #6: INTO and PIPE Operator in PLSQL
    :- • PL/SQL Tutorial #6: IN...
    PL/SQL Tutorial #7: Simple declaration and dynamic declaration in PLSQL
    :- • PL/SQL Tutorial #7: Si...
    PL/SQL Tutorial #8: Declaration by using %Rowtype OR Table based record in PLSQL
    :- • PL/SQL Tutorial #8: De...
    Full Blogs Link:-
    oracleshooter....
    PlayList:- PLSQL
    Concept :- #IF #CASE
    Related Playlist:-
    1. SQL
    :- • SQL
    2. Oracle Apps Technical
    :- • Oracle Apps Technical
    3. OAF
    :- • OAF
    4. Unix / Linux
    :- • Unix / Linux
    5. Company Knowledge
    :- • Company Knowledge
    6. Information
    :- • Information
    7. Oracle ERP
    :- • Oracle ERP
    8. PLSQL
    :- • PLSQL
    My Vlog Channel link:-
    / mylifemyface
    Contact Info:-
    Instagram:- / mylifemyface
    Facebook :- / mylifemyface11
    Twitter :- / mylifemyface11
    Blogger :- oracleshooter....
    Email Id :- oracle.shooter@gmail.com
    Telegram Link:- t.me/joinchat/...
    whatsapp Group :- chat.whatsapp....

ความคิดเห็น • 9

  • @SoaibAkhtar-j7d
    @SoaibAkhtar-j7d 2 หลายเดือนก่อน +1

    declare
    x number := 0;
    begin
    loop
    dbms_output.put_line('inside loop : x = ' || x);
    x := x + 1;

    if x > 3 then
    continue;
    end if;

    dbms_output.put_line('inside loop, after continue : x = ' || x);

    if x = 5 then
    exit;
    end if;
    end loop;
    dbms_output.put_line('after loop : x = ' || x);
    end;

  • @piyushrawat3693
    @piyushrawat3693 4 ปีที่แล้ว

    Gud job sir, varray next

  • @dalchandsorout9565
    @dalchandsorout9565 2 ปีที่แล้ว

    Superb brother 👌👌

  • @vickypatekar9532
    @vickypatekar9532 4 ปีที่แล้ว

    Great !

  • @irajthombre
    @irajthombre 4 ปีที่แล้ว

    Thank you 🙏🙏

  • @sahilmehmood6335
    @sahilmehmood6335 2 ปีที่แล้ว

    thank you sir

  • @ziauddin4513
    @ziauddin4513 ปีที่แล้ว

    Did not get and sorry to say Your way of understanding is not correct at all.

    • @UsmanKhan-wc1bs
      @UsmanKhan-wc1bs ปีที่แล้ว +1

      bro clear your basic concepts and then you understand. he is understanding to us in very nice way