Cursors in Oracle PL/SQL | Oracle PLSQL concepts

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ธ.ค. 2024
  • This video is to understand the concept of Oracle PL/SQL Cursors. Here we discuss implicit cursor, explicit cursor, difference between open-fetch-close and for loop cursors.
    Also here we will discuss various cursor attributes that will help you to get more details about the cursors.
    The video includes tutorial on how to work with Oracle PL/SQL Cursor in everyday programming.

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

  • @senthil7590
    @senthil7590 4 ปีที่แล้ว +2

    i gone through so many pl/sql videos, but your videos are really good and explained very well. Thank you ..

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

    Thanks for sharing this video!
    How to return cursor type variable to the procedure.... like how to write out parameter of cursor type variable in procedure
    thanks in advance!!

  • @MdArman-uu3vs
    @MdArman-uu3vs 7 ปีที่แล้ว

    very helpful vid..thank u.

  • @ipseetasahu9328
    @ipseetasahu9328 7 ปีที่แล้ว +1

    I have a question regarding cursor.
    select * from emp; is which type of cursor?

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      ipseeta sahu it would be an implicit cursor, as user is not taking care to open - fetch - close the cursor, nor is there any for loop..

    • @ipseetasahu9328
      @ipseetasahu9328 7 ปีที่แล้ว

      Kishan Mashru, Thanks for your reply.

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      Welcome, if you have enjoyed d video. please do like it and subscrib to the channel!!!

  • @bishalgupta7299
    @bishalgupta7299 5 ปีที่แล้ว +1

    instead of writing 'select * from employees'. i want to create a stored procedure and call it using cursor. Can you let me know how to do that?

  • @arunrajr12345
    @arunrajr12345 7 ปีที่แล้ว

    Hi could u help me ..i have an issue

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      ofcourse, you can always post the questions in the comment and I'll look into it!!!