SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

Which of the 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
How to Select last N records from a Table?What does preemptive in preemptive multitasking mean?