dgs!
Member³
When I use FORALL and MERGE together, the formatter seems to have given up. The MERGE statement is not moving to the next line.
Example:
FORALL i IN fct_tbl.first .. fct_tbl.last MERGE INTO tablename
I would like to see:
FORALL i IN fct_tbl.first .. fct_tbl.last
MERGE INTO tablename
Also, the INSERT statement is not moving to the next line:
WHEN NOT MATCHED THEN INSERT(column_name
I would like to see:
WHEN NOT MATCHED THEN
INSERT(column_name
The statement itself seems to be working, but the formatting is difficult to look at.
If I change the statement into a regular FOR/NEXT loop the formatter behaves correctly.
Any advice on changes that need to be made to my beautifier table?
Example:
FORALL i IN fct_tbl.first .. fct_tbl.last MERGE INTO tablename
I would like to see:
FORALL i IN fct_tbl.first .. fct_tbl.last
MERGE INTO tablename
Also, the INSERT statement is not moving to the next line:
WHEN NOT MATCHED THEN INSERT(column_name
I would like to see:
WHEN NOT MATCHED THEN
INSERT(column_name
The statement itself seems to be working, but the formatting is difficult to look at.
If I change the statement into a regular FOR/NEXT loop the formatter behaves correctly.
Any advice on changes that need to be made to my beautifier table?