- assigned_to: nobody --> roirex
It would be nice to have a SQL Beautifier, to make a long SQL look nice, like this:
SELECT * FROM (SELECT /*+ ALL_ROWS */ distinct main.cdr_head_css_id, main.cdr_head_utc_time, main.cdr_head_unique_id, main.cdr_head_session_id, rownum rn FROM (SELECT cdr_msk_cdr_vs.cdr_head_css_id, cdr_msk_cdr_vs.cdr_head_utc_time, cdr_msk_cdr_vs.cdr_head_unique_id, cdr_msk_cdr_vs.cdr_head_session_id FROM cdr_msk_cdr_vs WHERE cdr_head_css_id = 1001003 AND cdr_head_utc_time >= TO_DATE('2008-01-01 00:00:00.0','YYYY-MM-DD HH24:MI:SS.#') AND cdr_head_utc_time <= TO_DATE('2008-12-31 23:59:00.0','YYYY-MM-DD HH24:MI:SS.#') order by cdr_head_css_id asc, cdr_head_utc_time asc) main, (select id, name AS disCol_1000060 from billing_event_type) tab_1000060 WHERE main.bet_id = tab_1000060.id(+)) WHERE rn >= 1 AND rn < 21 order by cdr_head_css_id asc, cdr_head_utc_time asc