SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

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

Download SQL Interview Questions And Answers PDF

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 ?