General SQL Parser and SQL Pretty Printer Formatter options

Index

Available format options for white spaces:

gFmtOpt.WSPadding_OperatorArithmetic

Type: boolean

Default: true

---

Example format options:

Name	Value
gFmtOpt.WSPadding_OperatorArithmetic	false

Formatted SQL:

SELECT * 
FROM   dual 
WHERE  1=-1 
       AND(1!=2 
            OR 2^=3) 
       AND 3<>4 
       AND 4>5; 

---

Example format options:

Name	Value
gFmtOpt.WSPadding_OperatorArithmetic	true

Formatted SQL:

SELECT * 
FROM   dual 
WHERE  1 = -1 
       AND(1 != 2 
            OR 2 ^= 3) 
       AND 3 <> 4 
       AND 4 > 5; 

---

gFmtOpt.WSPadding_ParenthesesInFunction

Type: boolean

Default: false

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesInFunction	false

Formatted SQL:

CREATE FUNCTION sales.Fn_salesbystore
  (@storeid INT) 
RETURNS TABLE 
AS 
  RETURN 0; 

---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesInFunction	true

Formatted SQL:

CREATE FUNCTION sales.Fn_salesbystore
  ( @storeid INT ) 
RETURNS TABLE 
AS 
  RETURN 0; 

---

gFmtOpt.WSPadding_ParenthesesInExpression

Type: boolean

Default: true

---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesInExpression	true

Formatted SQL:

SELECT (( ( a - b ) - c )) 
FROM   t 



---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesInExpression	false

Formatted SQL:

SELECT (((a - b) - c)) 
FROM   t 



---

gFmtOpt.WSPadding_ParenthesesOfSubQuery

Type: boolean

Default: false

---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesOfSubQuery	false

Formatted SQL:

SELECT last_name 
FROM   employees 
WHERE  salary > (SELECT salary 
                 FROM   employees 
                 WHERE  last_name = 'Abel'); 



---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesOfSubQuery	true

Formatted SQL:

SELECT last_name 
FROM   employees 
WHERE  salary > ( SELECT salary 
                  FROM   employees 
                  WHERE  last_name = 'Abel' ); 



---

gFmtOpt.WSPadding_ParenthesesInFunctionCall

Type: boolean

Default: false

---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesInFunctionCall	false

Formatted SQL:

SELECT department_id,
       Min(salary) 
FROM   employees 
GROUP  BY department_id 



---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesInFunctionCall	true

Formatted SQL:

SELECT department_id,
       Min( salary ) 
FROM   employees 
GROUP  BY department_id 



---

gFmtOpt.WSPadding_ParenthesesOfTypename

Type: boolean

Default: false

---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesOfTypename	false

Formatted SQL:

CREATE TABLE datatype 
  (fld0 GENERICTYPE,
   fld1 CHAR(2),
   fld3 NCHAR(1)); 



---

Example format options:

Name	Value
gFmtOpt.WSPadding_ParenthesesOfTypename	true

Formatted SQL:

CREATE TABLE datatype 
  (fld0 GENERICTYPE,
   fld1 CHAR( 2 ),
   fld3 NCHAR( 1 ));