Difference between View and Cursor
A cursor is defined and used within the scope of a stored procedure (it is used with PL/SQL) and views are used to retrieve data or Update the data.
On the other hand, a view is a database object (similar to a table), which can be used even outside of stored procedures as well, as in queries (it can be used with both SQL and PL/SQL) and cursors are used to execute the data row by row or
record by record.
There is no affect in DB while changing in both cases.
