Oracle Cursors

Oracle Cursor

Cursor are pointers and they point to one row at time. Data is on PGA where a private area is created with the name of cursor.

Cursor give us better control over the data, as we can iterate data row by row.

Type of cursor
1. Implicit Cursor  - managed by oracle, user cannot control that
2. Explicit Cursor  - user defined

SQL Concept

Aim of this Blog:

• Introduction to SQL
• Evolution of Database
• Introduction to PL/SQL

What is SQL?

SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. 

SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.

More Topics 

• Database History

• What is PL/SQL
• SQL STATEMENTS CATEGORY'S (DDL / DML/ DCL/ TCL)

• Transaction Scope
• Locking & Isolation Levels
• COMMIT_ROLLBACK_SAVEPOINT

• Anonymous Block
• VARIABLE
• BIND VARIABLE 
• PL/SQL COLLECTION TYPE
• SQL Functions
• SQL NULL Functions

Additional Topics 

• Delete Duplicate Rows
• Toad Shortcuts
• Query Execution Error Sequence
• Why DML are not allowed inside procedure
• Sub Query Returning multiple column with IN clause
• Working with Single Quote in Data