Formatter · Oracle

Format Oracle SQL online

Reformat Oracle queries against Oracle's own grammar: consistent indentation, aligned clauses and uppercase keywords. Paste one-line or ORM-generated SQL and get structured, reviewable output.

1Paste your Oracle query into the editor.

2Press Format — or ⌘↵.

3Copy clean, highlighted SQL.

Open formatter

before

select e.employee_id,e.first_name||' '||e.last_name as name,nvl(e.commission_pct,0) comm,to_char(e.hire_date,'YYYY-MM') hired from employees e where e.department_id=10 and rownum<=20 order by e.hire_date desc;

Oracle

SELECT
  e.employee_id,
  e.first_name || ' ' || e.last_name AS NAME,
  nvl(e.commission_pct, 0) comm,
  to_char(e.hire_date, 'YYYY-MM') hired
FROM
  employees e
WHERE
  e.department_id = 10
  AND rownum <= 20
ORDER BY
  e.hire_date DESC;

Why format Oracle?

Oracle (PL/SQL) has a dialect all its own: ROWNUM paging instead of LIMIT, NVL/DECODE, the || concatenation operator, TO_CHAR/TO_DATE and dual. The formatter parses against Oracle's grammar so these constructs and (+) outer-join syntax stay intact instead of being mangled.

Especially handy for the dense queries copied out of SQL Developer or Toad, where everything lands on one line and ROWNUM logic is easy to misread.

All SQL formatters & beautifiers

Format PostgreSQL Beautify PostgreSQL

Format MySQL Beautify MySQL

Format T-SQL Beautify T-SQL

Format SQLite Beautify SQLite

Format BigQuery Beautify BigQuery

Format Oracle Beautify Oracle

Format Snowflake Beautify Snowflake

Format Redshift Beautify Redshift