CodeNeat

SQL Formatter for Oracle PL/SQL

Your data never leaves your browser

Oracle SQL includes ROWNUM, DECODE, and hierarchical queries.

Example

SELECT name, DECODE(status, 'A', 'Active', 'I', 'Inactive') as status_text, ROW_NUMBER() OVER (PARTITION BY dept_id ORDER BY salary DESC) as rank FROM employees WHERE ROWNUM <= 1000;
Try Sql Formatter Now

Tips

  1. 1Select PL/SQL for DECODE, NVL, TO_DATE.
  2. 2ROWNUM for row limiting.
  3. 3Format packages clearly.

Frequently Asked Questions

Oracle functions?

Yes. DECODE, NVL, CONNECT BY.

PL/SQL blocks?

SQL formats. BEGIN/END: basic support.

FETCH FIRST?

Yes. Oracle 12c+.