Practice exercise
- Which of the following features are not available in SQL Developer?
- Query builder.
- Database export and import.
- Database backup and recovery functions.
- Code Subversion repository.
- For a function to be called from a SQL expression, which of the following conditions should it obey?
- A function in the
SELECT
statement should not contain DML statements. - The function should return a value.
- A function in the
UPDATE
orDELETE
statement should not query the same table. - A function called from a SQL expression cannot contain TCL (
COMMIT
orROLLBACK
) commands or DDL (CREATE
orALTER
) commands.
- A function in the
- The following query is executed in the SCOTT schema:
SELECT NAME, referenced_owner, referenced_name FROM all_dependencies WHERE owner = USER AND referenced_type ...
Get Advanced Oracle PL/SQL Developer's Guide - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.