Shortcut to declare variables in PL/SQL
Answered
For Java, IntelliJ offers the var postfix completion that allows me to assign an expression to a newly created variable.
"some string".var becomes String s = "some string";
Is there a way to achieve something similar for PL/SQL so that
BEGIN
'some string'.var
END
becomes
DECLARE
s VARCHAR2(100);
BEGIN
s := 'some string';
END
?
Please sign in to leave a comment.
You can create your custom template for postfix completion for SQL.