While stored routines are a great way to store and reuse logic in code as required, they do have some disadvantages. You will learn what these are. You will also be introduced to the concept of cursors. Cursors are used to individually process each row that is returned in a query. In the upcoming video, Prof. Ramanathan will take you through an example and explain how cursors are used in it.
While using either a UDF or a stored procedure in MySQL, it is important to remember that it is not portable across different database engines.
With this, you have come to the end of this session. In this session, you learnt about some of the advanced SQL concepts. So, let’s summarise the various topics and the syntax used for these concepts in the final segment.