1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ2

PL/SQL Language Fundamentals

Which two statements are true about conditional compilation in PL/SQL with $IF, $ELSE, $END, and $ERROR?

Choose two
  • A PL/SQL code can be compiled and executed based on different versions of the operating system.
  • B PL/SQL code can be compiled and executed based on different versions of Oracle.
  • C It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
  • D Conditional compilation is disabled by default.
  • E The PL/SQL compiler can conditionally include selected parts of a program.
Explanation

Conditional compilation uses selection directives to choose the source text that the PL/SQL compiler includes. Database-version information, including that supplied through DBMS_DB_VERSION, can control which code is compiled for different Oracle Database versions. Oracle Database PL/SQL Language Reference — Conditional Compilation

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!