Skip to content

Navigation Menu

Appearance settings

GitHub Copilot
Write better code with AI

GitHub Spark New
Build and deploy intelligent apps

GitHub Models New
Manage and compare prompts

GitHub Advanced Security
Find and fix vulnerabilities

Actions
Automate any workflow
Codespaces
Instant dev environments

Issues
Plan and track work

Code Review
Manage code changes

Discussions
Collaborate outside of code

Code Search
Find more, search less
Explore

Why GitHub

Documentation

GitHub Skills

Blog
Integrations

GitHub Marketplace

MCP Registry
View all features
By company size

Enterprises

Small and medium teams

Startups

Nonprofits
By use case

App Modernization

DevSecOps

DevOps

CI/CD

View all use cases
By industry

Healthcare

Financial services

Manufacturing

Government

View all industries
View all solutions
Topics

AI

DevOps

Security

Software Development

View all
Explore

Learning Pathways

Events & Webinars

Ebooks & Whitepapers

Customer Stories

Partners

Executive Insights
GitHub Sponsors
Fund open source developers
The ReadME Project
GitHub community articles
Repositories

Topics

Trending

Collections
Enterprise platform
AI-powered developer platform
Available add-ons

GitHub Advanced Security
Enterprise-grade security features

Copilot for business
Enterprise-grade AI features

Premium Support
Enterprise-grade 24/7 support
Pricing

Search code, repositories, users, issues, pull requests...

Search

Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

Include my email address so I can be contacted

Saved searches

Use saved searches to filter your results more quickly

Name

Query

To see all available qualifiers, see our documentation.

Appearance settings

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Dismiss alert

sqlparser / sql-pretty-printer Public

Notifications You must be signed in to change notification settings
Fork 13
Star 52

Code
Issues 7
Pull requests
Actions
Projects
Wiki
Security
Insights

Additional navigation options

Code
Issues
Pull requests
Actions
Projects
Wiki
Security
Insights

SQL expression

Jump to bottom Edit New page

Tako Lee edited this page Feb 21, 2014 · 9 revisions

Condition with logical structure
String concate with max line width
How to break long expression

PP V3 format options

Toggle table of contents Pages 143

Home
Add parentheses in expressions containing more than one identifier or literal
Align oracle PLSQL operators
Align parameters in function call
Align style
Align Style Stacked option type
Align the IN and OUT keywords of parameter declaration
Alignment create table field
Alignments
Alignments main keywords
Alignments select list column alias
Assignment Option type
Blank lines
Blank lines(vertical spacing) in multiple SQLs
Case expression
Comments
Common table expression
Compact mode
Compact option type
Comparison of new and old format options
Condition with logical structure
Create table statement
Declare
Default option
EmptyLines option type
Execute
From clause
From clause (join)
Group by clause
Having clause
Indentation general indentation size
Indentation if statement
Indentation PLSQL exception
Insert statement
Line number
Line width
List of format options
Order by clause
Output Type
Padding PLSQL operators and keywords
Padding spaces precede and follow character (') literals.
PL SQL Vertical Spacing Best Practices Standards
PP V3 format options
PPV3 Create Table
PPV3 Select from clause
PPV3 Select list
Preprocessor
Refactor
Remove redundant brackets in condition
Select
Select as subquery
select column list comma
select column list style
Select into clause
Select list
Space
Space around operator of arithmetic expression
Space inside parenthesis of expression
Space inside parenthesis of function call
Space inside parenthesis of parameter definition of create function procedure
Space inside parenthesis of subquery
Space inside parenthesis of type name specification of create table statement
SQL align option
SQL block indentation
SQL capitalization
SQL capitalization alias
SQL capitalization builtinfunc
SQL capitalization case identifier
SQL capitalization column
SQL capitalization column alias
SQL capitalization datatype
SQL capitalization funcname
SQL capitalization function
SQL capitalization identifier
SQL capitalization keywords
SQL capitalization options
SQL capitalization Prefixed Identifier
SQL capitalization Quoted Identifier
SQL capitalization table
SQL capitalization variable
SQL clause structure
SQL Coding Standard and Guideline
SQL DB Vendor
SQL expression
SQL FaaS
SQL FaaS API manual
SQL format boolean option
SQL format int option
SQL format vertical spacing
SQL function
SQL how to break long expression
SQL HTML and RTF output
SQL indentation begin and end function indent
SQL indentation general
SQL indentation tab size
SQL indentation use tab
SQL IndentLen
SQL layout reservation
SQL list comma option
SQL list style
SQL logical condition operator AND OR option
SQL organisation
SQL Output format
SQL Parameters
SQL Preview
SQL preview alignment main keywords
sql preview alignments select list column alias
SQL preview blank lines(vertical spacing) in multiple SQLs
SQL preview capitalization identifier
SQL preview capitalization keywords and datatype
SQL preview case expression
SQL preview common table expression
SQL preview create table
SQL preview declare statement
SQL Preview document generation
SQL preview indentation sql block
sql preview insert statement
SQL preview layout reservation
SQL preview Oracle PL SQL operators
SQL preview PL SQL Vertical Spacing
sql preview select list
SQL preview SQL Parameters
SQL preview SQL server execute statement
SQL preview SQL Server Go Statement
SQL preview SQL Server set statement
SQL preview update statement
SQL preview web UI
SQL preview web UI design
SQL preview whitespace padding
SQL refactor
SQL Server
SQL Server create function procedure
SQL Server declare statement
SQL Server execute statement
SQL Server Go Statement
SQL Server set statement
SQL XML related query
String concate with max line width
Subquery
Syntax highlighting
Update statement
Where clause
Whitespace

Add a custom sidebar

Clone this wiki locally

Footer

© 2025 GitHub, Inc.

Footer navigation

Terms
Privacy
Security
Status
Community
Docs
Contact

You can’t perform that action at this time.