SQL (Structured Query Language) Question:

Which Oracle supplied package will enable this feature?

SQL Interview Question
SQL Interview Question

Answer:

A stored function must return a value based on conditions that are determined at runtime. Therefore, the SELECT statement cannot be hard-coded and must be created dynamically when the function is executed. Which Oracle supplied package will enable this feature?
1. DBMS_DDL
2. DBMS_DML
3. DBMS_SYN
4. DBMS_SQL


Previous QuestionNext Question
Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?How to implement ISNUMERIC function in SQL *Plus ?