| gFmtOpt.BEStyle_createtable_leftBEOnNewline | Type: boolean | Default: false |
| gFmtOpt.BEStyle_createtable_rightBEOnNewline | Type: boolean | Default: false |
| gFmtOpt.Createtable_ListitemInNewLine | Type: boolean | Default: false |
| gFmtOpt.Createtable_Fieldlist_Align_option | Type: TAlignOption | Default: aloLeft |
| gFmtOpt.DefaultAligntype | Type: TAlignStyle | Default: asStacked |
| gFmtOpt.DefaultCommaOption | Type: TLinefeedsCommaOption | Default: lfAfterComma |
Example format options:
| Name | Value |
| BEStyle_createtable_leftBEOnNewline | false |
| BEStyle_createtable_rightBEOnNewline | false |
| Createtable_ListitemInNewLine | false |
| Createtable_Fieldlist_Style_option | aloLeft |
Formatted SQL:
CREATE TABLE dept(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13))
Example format options:
| Name | Value |
| BEStyle_createtable_leftBEOnNewline | true |
| BEStyle_createtable_rightBEOnNewline | true |
| Createtable_ListitemInNewLine | true |
| Createtable_Fieldlist_Style_option | aloLeft |
Formatted SQL:
CREATE TABLE dept
(
deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13)
)
Example format options:
| Name | Value |
| BEStyle_createtable_leftBEOnNewline | true |
| BEStyle_createtable_rightBEOnNewline | true |
| Createtable_ListitemInNewLine | true |
| Createtable_Fieldlist_Style_option | aloRight |
Formatted SQL:
CREATE TABLE dept
(
deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13)
)
Example format options:
| Name | Value |
| gFmtOpt.DefaultAligntype | asStacked |
| gFmtOpt.DefaultCommaOption | lfbeforeCommaWithSpace |
Formatted SQL:
CREATE TABLE dept(
deptno NUMBER(2)
, dname VARCHAR2(14)
, loc VARCHAR2(13))
Example format options:
| Name | Value |
| gFmtOpt.DefaultAligntype | asWrapped |
Formatted SQL:
CREATE TABLE dept(
deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13))