Format complex sql and plsql codes using sqlinform notepad++ plugin

 Objective: format complex sql and plsql codes using sqlinform notepad++ plugin

The objective of this video is to quickly show how to quickly format multiline sql or plsql code poorly formatted for example the whole code is present in 1 line with carriage return or the code isnt in readable form.

Solution to use: sqlinform plugin for notepad++ [ the same tool is available for visual studio, dbeaver etc.. ]

Download source: https://www.sqlinform.com/download-free-notepad-plugin/

Steps:

1. Download 32bit of 64bit of your requirement

2. Open notepad++, findout the plugin location

3. Create a folder called SQLinFormNpp or SQLinFormNpp64 and then copy the downloaded plugin over here

4. Restart the notepad++

5. Now choose the sql file ill formated and start beautifying it :)

Reference: https://stackoverflow.com/questions/75032400/notepadd-plugin-sqlinform-for-sql-formatting-bright-orange-color-background

Thanks