Given the following function:CREATE FUNCTION emplist ()RETURNS TABLE ( id CHAR(6), firstname VARCHAR(12), lastname VARCHAR(15) )LANGUAGE SQL -BEGIN ATOMIC -RETURN -SELECT EMPNO, FIRSTNME, LASTNAMEFROM EMPLOYEE -WHERE WORKDEPT IN ('A00', 'B00');END -How can this function be used in an SQL statement?
A. SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B. SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C. SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D. SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
Given the following function:CREATE FUNCTION emplist ()RETURNS TABLE ( id CHAR(6), firstname VARCHAR(12), lastname VARCH
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Given the following function:CREATE FUNCTION emplist ()RETURNS TABLE ( id CHAR(6), firstname VARCHAR(12), lastname VARCH
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!