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

Source: Internet
Author: User

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 % \';

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.