Home > SQL Developer Dialog Boxes ... > Format Properties (Advanced...
The Format Properties box is displayed if you right-click and select Advanced Format in the SQL Worksheet or the editor for a subprogram, package, view, or trigger. You can specify a set of formatting rules different from those if you had selected Format (that is, different from the Database: SQL Formatter user preferences).
Output Destination: Editor applies the selected Output Type formatting in the current editing pane; Clipboard applies the formatting on the clipboard, so that you can paste it into a pane or window of your choice.
Output Type: A set of formatting rules associated with an output type: SQL or another type from the list. You can test several output types on a statement in the SQL Worksheet (pasting or reentering the statement each time). For example, if the original statement is entered as:
select 1 from dual
The result with the following output types is:
SQL: SELECT 1 FROM dual
Java StringBuffer: SQL.append("SELECT 1 FROM dual");
Enclosed In: Not Enclosed
(for example, SELECT 1 FROM dual)
, "
(for example, when embedded in Java: SQL.append("SELECT 1 FROM dual");
) or, '
(for example, in MSSQL string: N'SELECT 1 FROM dual')
).
Escaped By: A character that can be used for "escaping" the Enclosed In character. When Enclosed In is " or ', that character can be escaped by itself or by the Escaped By character. For example, if Escaped By is \
and the input is SQL.append("SELECT 1 \"one\" FROM dual");
, it will be formatted as SELECT 1 "one" FROM dual
.