We are moving soon! A faster, fresher and bigger DWBI Website is on your way. Follow us here.

pl/sql question

posted in Performance Tuning
Tuesday, August 28 2012, 03:10 PM
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.