Oracle SQL Formatter
Use this free online Oracle SQL Formatter to format Oracle SQL and PL/SQL. It works instantly in your browser, and your data never leaves your device.
About the Oracle SQL Formatter
Unformatted SQL is hard to review, especially long joins and subqueries. This oracle sql formatter uses a dialect aware parser for Oracle syntax, puts each clause on its own line, indents subqueries and lets you choose keyword case and indentation.
Also known as: plsql formatter.
How to use the Oracle SQL Formatter
- Paste your input into the box above, upload a file, or click Sample to try an example.
- Pick any options you need. The Oracle SQL Formatter processes your input instantly as you type.
- Click Copy to copy the output or Download to save it as a file.
Features
- Free with no signup and no daily limits
- Private: runs entirely in your browser
- Works on mobile, tablet and desktop
- Upload files and download results
- Live results as you type, with clear error messages
- Clean, fast interface with no popups
Frequently asked questions
Is the Oracle SQL Formatter free to use?
Yes. The Oracle SQL Formatter is completely free with no signup, no limits on normal use and no watermark.
Is my data safe?
Yes. Everything is processed by JavaScript inside your own browser. Your text is never uploaded to our server or stored anywhere.
Which SQL dialects are supported?
Standard SQL, MySQL, MariaDB, PostgreSQL, SQL Server (T-SQL), Oracle PL/SQL, SQLite, BigQuery, Snowflake, Redshift, Spark SQL and DB2.
Does formatting change my query?
No. Only whitespace, line breaks and optionally keyword case change. The logic of the query stays exactly the same.
What else is this tool called?
People also search for it as plsql formatter. It is the same free tool.