文件名称：Oracle SQL实用讲解，最基本最实用的相关讲解
文件大小：3.2MB
文件格式：DOCX
更新时间：2022-08-28 17:29:46
Oracle 函数 调优 clause
WITH –-小九九算法 t_base AS (SELECT LEVEL AS lv FROM dual CONNECT BY LEVEL <= 9), t_join AS (SELECT a.lv lv_a, b.lv lv_b, to_char(b.lv) || 'X' || to_char(a.lv) || '=' || rpad(to_char(a.lv * b.lv), 2, ' ') AS text FROM t_base a, t_base b WHERE b.lv <= a.lv) SELECT listagg(t_join.text, ' ') within GROUP(ORDER BY t_join.lv_b) AS m99 FROM t_join GROUP BY t_join.lv_a;