A cursor can take parameters, which can appear in the associated query wherever constants can appear.

fetching and updating cursors-5

PL/SQL also conforms to the current ANSI/ISO SQL standard.

In addition to static SQL discussed in this chapter, PL/SQL also supports dynamic SQL, which enables you to execute SQL data definition, data control, and session control statements dynamically.

A transaction is a series of SQL data manipulation statements that does a logical unit of work.

For example, two statements might credit one bank account and debit another.

By extending SQL, PL/SQL offers a unique combination of power and ease of use.

You can manipulate Oracle data flexibly and safely because PL/SQL fully supports all SQL data manipulation statements (except ), transaction control statements, functions, pseudocolumns, and operators.For additional information on assigning values to PL/SQL variables, see "Assigning a SQL Query Result to a PL/SQL Variable".Oracle is transaction oriented; that is, Oracle uses transactions to ensure data integrity.If you want precise control over query processing, you can declare an explicit cursor in the declarative part of any PL/SQL block, subprogram, or package.You must declare an explicit cursor for queries that return more than one row.Implicit cursors are managed automatically by PL/SQL so you are not required to write any code to handle these cursors.