Enhancement Request : Beautifier Options for Where-clause ...

[orca777]

I do not know if i had posted this but to remember :

SQL1: Beautified

SELECT 'X'
                  INTO lc_found_gt_status
                  FROM stpr akt_stat,
                       stpr folg_stat
                 WHERE akt_stat.stpr_id = un_stpr_id AND
                       akt_stat.stpr_edi_buendelungs_nr = folg_stat.stpr_edi_buendelungs_nr AND
                       akt_stat.stpr_objtyp = folg_stat.stpr_objtyp AND
                       akt_stat.stpr_kategorie = folg_stat.stpr_kategorie AND
                       akt_stat.stty_stty_kuerzel = folg_stat.stty_stty_kuerzel AND
                       akt_stat.stpr_pk1 = folg_stat.stpr_pk1 AND akt_stat.stpr_pk2 = folg_stat.stpr_pk2 AND
                       akt_stat.stpr_id < folg_stat.stpr_id AND
                       nvl(folg_stat.stpr_nv_stop_kzn,
                           '#') <> 'J' AND rownum <= 1;

SQL2 : Beautifier Option in where-clause (UPDATE, SELECT, DELETE)

SELECT 'X'
                  INTO lc_found_gt_status
                  FROM stpr akt_stat,
                       stpr folg_stat
                 WHERE akt_stat.stpr_id                 = un_stpr_id
                   AND akt_stat.stpr_edi_buendelungs_nr = folg_stat.stpr_edi_buendelungs_nr
                   AND akt_stat.stpr_objtyp             = folg_stat.stpr_objtyp
                   AND akt_stat.stpr_kategorie          = folg_stat.stpr_kategorie
                   AND akt_stat.stty_stty_kuerzel       = folg_stat.stty_stty_kuerzel
                   AND akt_stat.stpr_pk1                = folg_stat.stpr_pk1
                   AND akt_stat.stpr_pk2                = folg_stat.stpr_pk2
                   AND akt_stat.stpr_id                 < folg_stat.stpr_id
                   AND nvl(folg_stat.stpr_nv_stop_kzn, '#') <> 'J' AND rownum <= 1;

See the alignement of AND to the SELECT-Clause i would like to have this even for GROUP BY/ORDER BY
and see the alignment of comparisons
For me SQL2 is much more readable!

Carl

 

[Marco Kalter]

We've had quite a few requests for this, so we'll add this for 6.0.