You learn how statements are connected by simple but powerful control structures that have a single entry and exit point. Collectively, these structures can handle any situation. Their proper use leads naturally to a well-structured program. They can be combined in any way necessary to deal with a given problem.
6 Performing SQL Operations from PL/SQL
A cursor is a variable that runs through the tuples of some relation. This relation can be a stored table, or it can be the answer to some query. This is too restrictive in many applications. Cursor is the mechanism that allow the program to step through the rows one at a time.
This does not apply to a BULK or multirow operation. Oracle is transaction oriented; that is, Oracle uses transactions to ensure data integrity. A transaction is a series of SQL data manipulation statements that does a logical unit of work. It is important not to allow one operation to succeed while the other fails.
It is a server-side, stored procedural language that is easy-to-use, seamless with SQL, portable, and secure. Because these blocks are not stored in the database, they are generally for one-time use. Functions are different than procedures in that functions return a value when executed. When you create a stored procedure or function, Oracle Database XE parses the procedure or function, and stores its parsed representation in the database. A package is a group of procedures, functions, and variable definitions that Oracle Database XE stores in the database.