SQL (Structured Query Language) Question:

Which Oracle supplied package will enable this feature?

Tweet Share WhatsApp

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

Read All 172 SQL Questions
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 ?