WITH AA AS 
(
SELECT '운영자' AS NAME, '빵'     AS LIST FROM DUAL UNION ALL
SELECT '운영자' AS NAME, '음료수' AS LIST FROM DUAL UNION ALL
SELECT '운영자' AS NAME, '과자'   AS LIST FROM DUAL UNION ALL
SELECT '운영자' AS NAME, '젤리'   AS LIST FROM DUAL
)
SELECT * FROM AA;

위와 같은 결과를 원합니다..