This blog post is to display the different formatting options for Oracle SQLDeveloper.
To indicate the first change I am using BOLD. I am using Oracle as the base set of options.
I am also using the PL/SQL example code as shipped in the preferences UI.
Option 1: Source SQL Copied out of Program code
Option 1: Source SQL Copied out of Program code.
Assumption, Source SQL: Enclosed in "
Used when SQL is contained in another language for example contained in Java, C or
even PL/SQL itself (as in the contrived example).
With option on:
With option off:
/* Comment... embedded in double quotes "select embedded_double_query from
/* Embedded in single quotes 'select embedded_single_query from mytable' */
CREATE OR REPLACE PACKAGE BODY test1
g_column1 VARCHAR2(17) := NULL;
g_column2 VARCHAR2(52) := NULL;
g_column3_from_column22 VARCHAR2(25) := NULL;
g_column_4711 VARCHAR2(11) := NULL;
Image verion TODO: make images/screen shots smaller with relatively bigger text - but still the
same size (consistent) for this web page.[removed data base details]
Go with shorter vertically and 'original size' but a bit smaller originally.
Option 1: (original size)
Option 2: ....
Option2: (extra large)