Advanced Oracle PL/SQL Developer's Guide - Second Edition

Practice exercise

• Which of the following features are not available in SQL Developer?
  1. Query builder.
  2. Database export and import.
  3. Database backup and recovery functions.
  4. Code Subversion repository.
• For a function to be called from a SQL expression, which of the following conditions should it obey?
  1. A function in the SELECT statement should not contain DML statements.
  2. The function should return a value.
  3. A function in the UPDATE or DELETE statement should not query the same table.
  4. A function called from a SQL expression cannot contain TCL (COMMIT or ROLLBACK) commands or DDL (CREATE or ALTER) commands.
• The following query is executed in the SCOTT schema:

   SELECT NAME, referenced_owner, referenced_name FROM all_dependencies WHERE owner = USER AND referenced_type ...