If there are multiple parameters on different lines with assignments, then there is no space between the data type and the ':='. When only a single parameter, there is a space. See the following formatted code fragment:
CREATE OR REPLACE PACKAGE test_pkg
AS
PROCEDURE my_proc1 (var1 IN NUMBER := 1, var2 IN NUMBER := 3);
PROCEDURE my_proc2 (var1 IN NUMBER := 1);
END;
If the formatting options have had the following change:
Statement & Clauses | Parameter declaration | Arrangement | List Arrangement | Stacked on Overflow on more than ... | 1 (column) :
CREATE OR REPLACE PACKAGE test_pkg
AS
PROCEDURE my_proc1 (var1 IN NUMBER:= 1, ****
var2 IN NUMBER:= 3); ****
PROCEDURE my_proc2 (var1 IN NUMBER := 1);
END;
**** note that the ':=' comes immediately after the data type when there should be a space betwee 'NUMBER' and ':='
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center