Three small settings for PLSQL developer

From: http://www.cnblogs.com/william-lee/archive/2010/12/08/1900176.html

1. You have written Multiple SQL statements in the SQL window. If you click "execute", all the statements in the window will be executed. If you want to execute the statements, You must select them.

So, is there any SQL statement that executes the cursor position like toad?

Yes. See the following settings:

2. Can keywords be automatically capitalized in addition to automatic induction when writing SQL statements? Format with SQL beautifierCodeYes. The lower-case keywords are also formatted in uppercase.

Yes. See the following settings:

However, if you use the PL/SQL beautifier to format the code, the table or table fields are also formatted in uppercase. You need to modify the beautifier settings:

Go to preferences and find the PLSQL beautifier settings. For example, note the case settings in "syntax case", because the keywords are set to uppercase just now, as a result, the setting here is the opposite. Just pay attention to the preview content.

3. Set the font of SQL code

The default English version is PLSQL developer. the font of the SQL code is Courier New. After the Chinese Language Pack is installed, it becomes ,. If you read the code for a long time, of course, it is not as good as the English font (SQL is English ). You can set it as follows:

From: http://www.cnblogs.com/william-lee/archive/2010/12/08/1900176.html

1. You have written Multiple SQL statements in the SQL window. If you click "execute", all the statements in the window will be executed. If you want to execute the statements, You must select them.

So, is there any SQL statement that executes the cursor position like toad?

Yes. See the following settings:

2. Can keywords be automatically capitalized in addition to automatic induction when writing SQL statements? The SQL beautifier formatting Code also converts lowercase keywords to uppercase.

Yes. See the following settings:

However, if you use the PL/SQL beautifier to format the code, the table or table fields are also formatted in uppercase. You need to modify the beautifier settings:

Go to preferences and find the PLSQL beautifier settings. For example, note the case settings in "syntax case", because the keywords are set to uppercase just now, as a result, the setting here is the opposite. Just pay attention to the preview content.

3. Set the font of SQL code

The default English version is PLSQL developer. the font of the SQL code is Courier New. After the Chinese Language Pack is installed, it becomes ,. If you read the code for a long time, of course, it is not as good as the English font (SQL is English ). You can set it as follows: