SQL> SELECT rowconcat('SELECT dname FROM dept') AS departments
  2    FROM dual;

DEPARTMENTS
--------------------------------------------------------------------------------
ACCOUNTING,RESEARCH,SALES,OPERATIONS