Toad does not format as expected based off of setting specified in the Formatter Options.
Example:
Data typEs and other reserved words should be capitalized. Spacing should have 5 character spaces between variable name and type
PROCEDURE TEST IS
my_var1 NUMBER; (5 space between data type and capital)
my_var2 PLS_INTEGER;
my_var3 VARCHAR2(30);
BEGIN
DBMS_OUTPUT.PUT_LINE('Variable 1'||my_var1);
END;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center