SQL Server's T-SQL and Oracle's PL/SQL are extensions of standard SQL. They both have procedural methods or operators in them. Most of the database platforms have some type of their own proprietary extensions to SQL.
Oracle implements cursors differently than SQL Server so I don't know how well you can compare them. Oracle also has several different types of cursors and it's not necessarily the same thing as cursor types in SQL Server.
Cursors are used a lot in Oracle and you can see them used frequently in best practices articles and performance tuning guidelines. With Oracle, cursors are pointers to a result set in a memory area. They are implemented implicitly with SQL statements if you haven't explicitly defined one. They can be incredibly fast. It doesn't mean explicit cursors in Oracle can't be abused but with the differences from SQL Server they are used differently and perform differently.

Sue