Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trivadis Code Formatting - repeat, update

Peter2_1Jan 14 2022 — edited Jan 14 2022

Edit:
More precise - it happens when the code is repeated.

I use the Trivadis settings for code formatting, and this code with repeated, similar lines is only formatted in the last "chapter":

-- 1
repeat update SECTION_INPUT_TEXT set rank_new = 1
where Rank = (select min(rank) from SECTION_INPUT_TEXT where fid_ma=$RFID )
for select distinct(fid_ma) RFID from SECTION_INPUT_TEXT ;
-- 2
repeat update SECTION_INPUT_TEXT set rank_new = 2
where Rank = (select min(rank) from SECTION_INPUT_TEXT where rank_new is null and fid_ma=$RFID )
for select distinct(fid_ma) RFID from SECTION_INPUT_TEXT where rank_new is null ;
-- 3
repeat update SECTION_INPUT_TEXT set rank_new = 3
where Rank = (select min(rank) from SECTION_INPUT_TEXT where rank_new is null and fid_ma=$RFID )
for
SELECT DISTINCT
    (FID_MA) RFID
  FROM
    SECTION_INPUT_TEXT
 WHERE
    RANK_NEW IS NULL;


Bug or Feature?

This post has been answered by Philipp Salvisberg on Jan 16 2022
Jump to Answer
Comments
Post Details
Added on Jan 14 2022
4 comments
206 views