Set plsqldev default format (uppercase keywords, other lower case), plsqldev keywords

Set plsqldev default format (uppercase keywords, other lower case), plsqldev keywords

Plsqldev has always been known to have the Formatting Function. After writing the SQL statement, it is also customary to click a button to format it, but you have never noticed that you can also set the Default Formatting. I learned from my colleague yesterday.

Default Formatting method:

Tools-> Preference-> User Interface-> PL/SQL Beautifier Interface, click Edit under Rules file, as shown below:

In the Syntax Case option area on the right, you can set upper-Case keywords and lower-Case keywords. You can also set other options. Save the settings as a. br file and select the saved format on the previous page.

Attach a piece of code to compare the effects before and after formatting:

Before formatting:

Click (here) to fold or open

1. Select * from t_ware_base t where t. warename like \ 'pwz % \';

After formatting:

Click (here) to fold or open

1. SELECT * FROM t_ware_base t WHERE t. warename LIKE \ 'pwz % \';