Beautifier x Bulk

[Gustavo]

This code

Update my_transactions
      Set    a = Null
      Where  a In ('N', 'E')
      And    t_date >= vd_start_date
      And    t_date < vd_end_date + 1
      Returning t_id Bulk Collect Into v_ids;

should be beautified like this

Update my_transactions
      Set    a = Null
      Where  a In ('N', 'E')
      And    t_date >= vd_start_date
      And    t_date < vd_end_date + 1
      Returning t_id
      Bulk Collect Into v_ids;

Regards,
Gustavo

 

[Marco Kalter]

I have added this to the list of enhancement requests.