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

?

0
1 comment
Avatar
Yuriy Vinogradov

You can create your custom template for postfix completion for SQL.

0

Please sign in to leave a comment.