List SQL statements allowed and not allowed in a PL/SQL block.

What will be an ideal response?


PL/SQL supports all the Data Manipulation Language (DML) statements such as
INSERT, UPDATE, and DELETE. It also supports the Transaction Control Language
statements ROLLBACK, COMMIT, and SAVEPOINT. You can retrieve data using the
data retrieval statement SELECT. A row of data can be used to assign values to
variables. More than one row can be retrieved and processed using cursors (covered in
the next chapter). PL/SQL statements can use single-row functions, but group functions
are not available for PL/SQL statements. SQL statements in PL/SQL block can still
utilize those group functions.
PL/SQL does not support Data Definition Language (DDL) statements such as CREATE,
ALTER, and DROP. The Data Control Language (DCL) statements GRANT and
REVOKE are not available in PL/SQL either.

Computer Science & Information Technology

You might also like to view...

You have written a single message for a complete movement. If you find that your animation are moving in a "jerky" fashion, you should try setting the animationStyle option to ____.

A. BEGIN_GENTLY_AND_END_ABRUPTLY B. BEGIN_ABRUPTLY_AND_END_GENTLY C. BEGIN_AND_END_ABRUPTLY D. BEGIN_AND_END_GENTLY

Computer Science & Information Technology

A loop ____ is an assertion that expresses a relationship between variables that remains constant throughout all iterations of the loop.

A. validation B. operator C. invariant D. variant

Computer Science & Information Technology

A Resource Record Signature (RRSIG) key contains the signature for a single resource record, such as an A or an MX record.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

After object code from a code library has been inserted into the object code for a requesting program, the resulting object code is often called a(n) ____ module.

baseline executable activated verified

Computer Science & Information Technology