SQL Developer Formatting
I am using SQL Developer Version 3.1.07 and found strange behanviour of SQL Developer formatting(Ctrl+F7). Here is an example.
DECLARE
X1 NUMBER :=0;
X2 NUMBER :=0;
X3 DATE;
X4 VARCHAR2(10) :='TEST';
BEGIN
NULL;
END;
If this code section is manually formatted using TAB, using Ctrl+F7 reverts it back to its original format as done previously. Subsequent attempts to reformat always yields the same results.
Manual Format:
DECLARE
X1 number :=0;
X2 NUMBER :=0;
X3 date;
X4 varchar2(10) :='TEST';
x5 date :=sysdate
BEGIN
NULL;
END;
Using Ctrl + F7 brings back to original state.
DECLARE
X1 NUMBER :=0;
X2 NUMBER :=0;
X3 DATE;
X4 VARCHAR2(10) :='TEST';