General SQL Parser and SQL Pretty Printer Formatter options

Index

Available format options for insert columns and values:

gFmtOpt.Insert_Columnlist_Style	Type: TAlignStyle	Default: asStacked
gFmtOpt.Insert_Valuelist_Style	Type: TAlignStyle	Default: asStacked
gFmtOpt.DefaultCommaOption	Type: TLinefeedsCommaOption	Default: lfAfterComma

---

Example format options:

Name	Value
gFmtOpt.Insert_Columnlist_Style	asStacked
gFmtOpt.Insert_Valuelist_Style	asStacked
gFmtOpt.DefaultCommaOption	lfAfterComma

Formatted SQL:

INSERT INTO employees
            (employee_id,
             first_name,
             last_name,
             email,
             phone_number,
             hire_date,
             job_id,
             salary,
             commission_pct,
             manager_id,
             department_id) 
VALUES     (113,
            'Louis',
            'Popp',
            'Ldd',
            '515.124.222',
            sysdate,
            'Ac_account',
            8900,
            NULL,
            205,
            100); 



---

Example format options:

Name	Value
gFmtOpt.Insert_Columnlist_Style	asStacked
gFmtOpt.Insert_Valuelist_Style	asWrapped
gFmtOpt.DefaultCommaOption	lfbeforeCommaWithSpace

Formatted SQL:

INSERT INTO employees
            (employee_id
             , first_name
             , last_name
             , email
             , phone_number
             , hire_date
             , job_id
             , salary
             , commission_pct
             , manager_id
             , department_id) 
VALUES     (113,'Louis','Popp','Ldd','515.124.222',sysdate,'Ac_account',8900,NULL,205,100);