What are the advantages of using CURSOR ??

Answer 1

Most likely you're talking about within a procedural sql language.

CURSORS are just a way to loop through data rows of a table, and perform a statement or action influenced by the data from that table row.

Kind of like the sql counterpart to do a "FOR loop"

Usually this is not recommended for extremely large tables, and there are many times when "set-based SQL" accomplishes the same results that a cursor would, but with way more efficiency

https://developer.teradata.com/blog/georgecoleman/2011/04/from-flat-logic-to-set-logic-a-basic-approach

Answer 2

its the subject of procedural language like pgsql,tsql or plsql ect

Answer 3

We can perform row by row processing so we can perform row wise validation or operations on each row....