No Code Completion in Merge Statement - 07/18/23 01:57 PM
Let's assume the following merge statement in PL/SQL code:
Observed behavior:
Code completion doesn't kick in and suggest fields of tables a and b in the on-clause while initially writing the merge statement.
Expected behavior:
All fields of tables using table-aliases should be recognized by the code completion, even if a merge statement is in an unfinished state while initially writing it.
PL/SQL Developer Version 15.0.4.2064 (64 bit)
Windows 10 Build 19045
Code
merge into table1 a using (select data2, data3 from table2) b on (a.field1 = b.data3) [...]
Observed behavior:
Code completion doesn't kick in and suggest fields of tables a and b in the on-clause while initially writing the merge statement.
Expected behavior:
All fields of tables using table-aliases should be recognized by the code completion, even if a merge statement is in an unfinished state while initially writing it.
PL/SQL Developer Version 15.0.4.2064 (64 bit)
Windows 10 Build 19045