Exam 1z0-149 All QuestionsBrowse all questions from this exam
Go to Exam
Question 43

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

    Correct Answer: C

    The correct method to reference a packaged constant in a SELECT statement involves using the full qualifying name of the constant (package_name.constant_name). SQL does not directly recognize PL/SQL constants unless they are fully qualified. Therefore, the correct option is using the fully qualified name in the SELECT statement.

Discussion
jfc1Option: C

C is the correct one

pmeyerOption: C

Constants not be used directly in SQL statements, correct is "C"!

Raju_thangavelOption: C

Answer C ?

2oracleexamOption: C

C is the answer

thranduylOption: C

C TESTED