SQL format options for where clause of select statement

General SQL Parser and SQL Pretty Printer Formatter options

Available format options for Where clause:

gFmtOpt.LinefeedsAndOr_option	Type: Boolean	Default: false
gFmtOpt.AndOrUnderWhere	Type: TLinefeedsAndOrOption = (lfbeforeAndOr,lfAfterAndOr,lfNolinebreak)	Default: lfbeforeAndOr
gFmtOpt.WhereClauseInNewline	Type: Boolean	Default: false
gFmtOpt.WhereClauseAlignExpr	Type: Boolean	Default: false

gFmtOpt.AndOrUnderWhere is valid only gFmtOpt.LinefeedsAndOr_option = lfbeforeAndOr, and gFmtOpt.WhereClauseInNewline = false.

Example format options:

Name	Value
gFmtOpt.LinefeedsAndOr_option	lfbeforeAndOr
gFmtOpt.AndOrUnderWhere	false
gFmtOpt.WhereClauseInNewline	false

Formatted SQL:


SELECT e.employee_id,

       e.last_name,

       e.department_id,

       d.department_id,

       d.locatioin_id 

FROM   employees e,departments d 

WHERE  e.department_id = d.department_id 

       AND e.last_name = 'Matos';

Example format options:

Name	Value
gFmtOpt.LinefeedsAndOr_option	lfAfterAndOr
gFmtOpt.AndOrUnderWhere	false
gFmtOpt.WhereClauseInNewline	false

Formatted SQL:

SELECT e.employee_id,
       e.last_name,
       e.department_id,
       d.department_id,
       d.locatioin_id
FROM   employees e,
       departments d
WHERE  e.department_id = d.department_id AND
       e.last_name = 'Matos';

Example format options:

Name	Value
gFmtOpt.LinefeedsAndOr_option	lfbeforeAndOr
gFmtOpt.AndOrUnderWhere	true
gFmtOpt.WhereClauseInNewline	false

Formatted SQL:


SELECT e.employee_id,

       e.last_name,

       e.department_id,

       d.department_id,

       d.locatioin_id 

FROM   employees e,departments d 

WHERE  e.department_id = d.department_id 

   AND e.last_name = 'Matos';

Example format options:

Name	Value
gFmtOpt.LinefeedsAndOr_option	lfbeforeAndOr
gFmtOpt.AndOrUnderWhere	false
gFmtOpt.WhereClauseInNewline	true

Formatted SQL:

SELECT e.employee_id,
       e.last_name,
       e.department_id,
       d.department_id,
       d.locatioin_id
FROM   employees e,
       departments d
WHERE
  e.department_id = d.department_id
  AND e.last_name = 'Matos';

Example format options:

Name	Value
gFmtOpt.LinefeedsAndOr_option	lfbeforeAndOr
gFmtOpt.AndOrUnderWhere	true
gFmtOpt.WhereClauseInNewline	false
gFmtOpt.WhereClauseAlignExpr	true

Formatted SQL:

SELECT *
FROM   vendor_l j,
       training_fy_qtr_month_v a
WHERE  b.training_category_id (+)    = a.training_category_id
   AND c.training_brn_id (+)         = a.training_brn_id
   AND c.fiscal_year_id (+)          = a.fiscal_year
   AND d.training_priority_id (+)    = a.training_priority_id
   AND e.training_status_id (+)      = a.training_status_id
   AND g.training_type_id (+)        = a.training_type_id
   AND g.training_sub_type_id (+)    = a.training_sub_type_id
   AND h.training_destination_id (+) = a.training_destination_id
   AND i.training_credit_type_id (+) = a.training_credit_type_id
   AND j.vendor_id (+)               = a.vendor_id