Skip to content

Bald DBA

All the DBA, None of the hair

  • About Me

format sql

Formatting SQL in Oracle

September 18, 2015 by Aaron

I was looking for a way to format the output from EXPAND_SQL_TEXT and came across this post. I would really rather have something in the database that I could do this with. I would prefer not to spool anything out, but it works very well.

Just another SQL beautifier

Categories Databases, PL/SQL, Programming, Shell Scripting Tags beautify, format sql, formatting, pretty sql Leave a comment

Recent Posts

  • Ransomeware Attack
  • RMAN table recovery error
  • Getting and formatting index ddl
  • pythonGit private repository
  • cx_Oracle ORA-24418

Recent Comments

    Archives

    • February 2023
    • May 2022
    • September 2021
    • September 2020
    • April 2020
    • March 2020
    • January 2020
    • September 2019
    • May 2019
    • April 2019
    • January 2019
    • October 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • August 2017
    • March 2017
    • February 2017
    • January 2017
    • September 2016
    • June 2016
    • March 2016
    • February 2016
    • November 2015
    • September 2015
    • August 2015
    • June 2015
    • March 2015
    • November 2014
    • September 2014
    • July 2014
    • June 2014
    • March 2014

    Categories

    • AIX
    • ASM
    • Clusterware
    • Crypto Currency
    • Databases
    • Dataguard
    • Datapump
    • Education
    • ESXi
    • Internals
    • Mining
    • mySQL
    • OEM
    • OEM 13c
    • OEM 13c
    • Operating Systems
    • Oracle
    • Patching
    • Performance Tuning
    • PL/SQL
    • Programming
    • Putty
    • Python
    • RAC
    • RMAN
    • Shell Scripting
    • Site Information
    • Software
    • SQL
    • Trouble Shooting
    • Uncategorized
    • Windows
    • Xming

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    © 2025 Bald DBA • Built with GeneratePress