oracle俩张表按当前日期创建数据条数并排序关联

WITH ll AS （
SELECT   ROWNUM AS cc  FROM DUAL CONNECT BY ROWNUM
<= TO_NUMBER(
TO_CHAR(LAST_DAY(SYSDATE-31), 'dd')
)
）, kk AS （
SELECT 1 rr,111 bb FROM dual
UNION ALL SELECT 2 日期,222 编号 FROM dual
UNION ALL SELECT 3 日期,333 编号 FROM dual
UNION ALL SELECT 4 日期,444 编号 FROM dual
UNION ALL SELECT 6 日期,666 编号 FROM dual
UNION ALL SELECT 7 日期,777 编号 FROM dual
UNION ALL SELECT 8 日期,888 编号 FROM dual
UNION ALL SELECT 9 日期,999 编号 FROM dual
）

SELECT *
FROM ll
LEFT JOIN kk
ON ll.cc = kk.rr
ORDER BY ll.cc

 

 

直接复制代码到PLSQL