atom-oracle-format

Quick and dirty SQL formatter using Oracle SQL Developer

Installation

With apm:

apm install oracle-format

Configuration

In the package configuration section, add the path to sdcli.exe or sdcli64.exe

Usage

Format editor content alt-ctrl-l/alt-cmd-l

Format SQL in package menu or context menu. Only runs in files using SQL grammar

⚠️ File will be saved before being formatted

🐌 This option has the worst performance. It takes a while... so be patient

Format file

Format SQL File in tree view context menu. Option visible on *.sql files only

Format folder

Format SQL Folder in tree view context menu. Option available on folders only

⚠️ Formats all the files in the folder, not only *.sql files

🐇 This is the most performant option

Why

• No hidden dependencies (only Oracle Developer for obvious reasons 😉)

  • Under corporate proxy installing packages may be difficult due to network limitations

  • Need of Python and Visual Studio to install packages (node-gyp errors) its a big restriction in some circumstances

• Maintain same formatting options throughout the entire code base

Contributions

Pull requests are welcome, big and small!

License

MIT © Pablo Escalada