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.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';