You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by
HIRE_DATE.
Examine the sample output:
Which query will provide the required output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10592/functions089.htm
B
B
Syntax structure:
LISTAGG( [,]) WITHIN GROUP (ORDER BY ) [OVER (PARTITION BY )]