Print Thread
No Code Completion in Merge Statement
#64726 07/18/23 01:57 PM
Joined: Apr 2020
Posts: 92
Z
zakko Offline OP
Member
OP Offline
Member
Z
Joined: Apr 2020
Posts: 92
Let's assume the following merge statement in PL/SQL code:

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

Re: No Code Completion in Merge Statement
zakko #64727 07/19/23 08:53 AM
Joined: Aug 1999
Posts: 22,212
Member
Offline
Member
Joined: Aug 1999
Posts: 22,212
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 15 (0.015s) Memory: 2.4957 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-09 08:20:12 UTC
Valid HTML 5 and Valid CSS