We just got bigger and better! Visit our new website DWBI.org →
Our community is shifted to a new home. And guess what - You will love it there!

pl/sql question

Hello Experts,

I have 2 questions related to db:-

1) Why do we make cursors ? Is there any alternative to achieve the same functionality without using cursors ? In which scenarios cursors are preferred.
2) what are the advantages of stored procedures over triggers ?

Responses (1)
  • Accepted Answer

    Friday, March 01 2013, 06:58 PM - #Permalink
    Cursors are like pointer to context area,We make use of cursors , to allocate and deallocate memory area.

    We make use of cursors in the scenario where query returns more then one rows.
    The reply is currently minimized Show
Your Reply

Specify a password to lock discussions to only users who has the password.