When typing an Oracle function name it would make a lot of sense to autocomplete the parameters with the long-hand parameter names.
With this function created and introspected.
CREATE OR REPLACE FUNCTION foo(p_bar_1 VARCHAR2, p_bar_2 NUMBER)
RETURN VARCHAR2 AS BEGIN RETURN p_bar_1 || p_bar_2;
When I type
It pops up with the parameters but I still have to type them. I would like to see it autocomplete to what it pops up with, in this case.
SELECT foo(p_bar_1 => NULL, p_bar_2 => NULL)
Is there a way to autocomplete this? I have functions with 20+ parameters and this auto-completion would be extremely helpful rather than typing them one at a time?