Practice exercise
- Which of the following dictionary views is used to get information about subprogram arguments?
ALL_OBJECTS
ALL_ARGUMENTS
ALL_DEPENDENCIES
ALL_PROGRAMS
- The tablespace information on a database server is as follows:
SELECT tablespace_name FROM DBA_TABLESPACES / TABLESPACE_NAME ---------------- SYSTEM UNDOTBS1 TEMP USERS EXAMPLE
You execute the following command in the session:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; Session altered.
Identify the correct statements:
- The identifier information would be captured by PL/Scope for the program created or compiled in the session.
- The identifier information would not be captured by PL/Scope as
IDENTIFIERS:ALL
can be enabled only at theSYSTEM
level. - The identifier information would ...
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.