问题

Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) first

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, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow 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

参考答案

您可能感兴趣的试题

The signs or cues of culture shock given by the author involve all of the following EXCEPT

答案解析
All of the following statements are correct EXCEPT that______.A．the statement is given by

答案解析
Which of the following is NOT the reason given in the passage for people to avoid discussi

答案解析
Which of the following advice is NOT given about the womans purse？A．Mending the hole in th

答案解析
Which of the following is false according to the information given in the passage?A.Fashio

答案解析
Directions: Read the following passage. Answer the questions according to the information given in t

答案解析