SQL*Plus (MOSC)

MOSC Banner

SQL Developer Formatting

edited Aug 2, 2012 9:17AM in SQL*Plus (MOSC) 6 commentsAnswered
Hi,

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center