Hi Marco, here is a sample:
BEGIN
DECLARE
CURSOR cur IS
/*
SELECT /*+ parallel (fct01,4) + parallel (spa,4) */
/*agr0.ROWID, spa.sper_id, spa.stct_id
FROM t_coverages_fct fct01, t_cvrg_agr0 agr0, t_sales_persons_agr spa
WHERE fct01.id = agr0.id
AND fct01.nat_key_spers_code = spa.nat_key_spers_code;
*/
SELECT --/*+ parallel (wk,4) */
agr0_rowid, sper_id, stct_id --, Id
FROM wk_tmp01 wk;
BEGIN
NULL;
END;
After beautifying some comment lines moves to right, forward after every beautifying.
Regards