Oracle Database PL/SQL shortcut key settings

This article describes how to set the shortcut keys for PLSQL in Oracle databases, including setting MyObjects, remembering the password, and double-clicking the display table by default.

This article describes how to set the shortcut keys for PL/SQL in Oracle databases, including setting My Objects, remembering the password, and double-clicking the display table by default.

This article describes how to set the shortcut keys for PL/SQL in Oracle databases, including setting My Objects, remembering the password, and double-clicking to display table data by default, hope to help you.

In Oracle databases, the PL/SQL shortcut setting method is what we will introduce in this article. We understand that these settings can be more efficient for using Oracle databases, next let's take a look at this part.

1. My Objects is automatically selected by default after logon.

By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after selecting My Objects, the response speed is calculated in milliseconds.

Setting method:

Tools menu --> Brower Filters. The order window of Brower Folders is opened, and "My Objects" is set to default.

Tools menu-Brower Folders: Move the directories you frequently clicked (for example, Tables Views Seq Functions Procedures) to a higher level and add colors to differentiate them, in this way, the average table searching time will be greatly shortened. Try again.

2. Remember the password

This is a controversial feature, Because remembering the password will cause data security issues. However, if the password is the same as the user name in the development database, it makes no sense to enter the password each time. Therefore, PLSQL Developer can remember the password.

Setting Method: menu Tools> Preferences> Oracle> Logon History> Store With Password

3. Double-click to display table data

The default response when double-clicking a table or view is really disappointing, because I am most concerned about the table structure and data, but none of these two things happen after double-clicking, the default response may be required by experts, but it is important for me to view data and table structures. I don't care about others. However, this can be set. You can double-click and drag and drop the mouse to bind the required event, for example, double-click to edit the data, drag and drop to display the table structure, Yeah!

Setting Method: choose Tools> Preferences> Browser to bind double-click and drag-and-drop operations to different Object types on the right.

4. All SQL statement characters are in uppercase

I think this is a good habit. The core of the information system is the database. When the system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful. SQL statements in uppercase cannot completely solve this problem, but it is easier to find a line of all uppercase characters in the middle of a pile of code. Thank you in your eyes.

Setting Method: menu Tools> Preferences> Editor> Keyword Case> Uppercase

5. Special Copy

The SQL statements written in the SQL Window usually need to be placed in Java or other languages, and you need to convert them into strings and add the corresponding hyphens. This does not need to be repeated, right-click the prepared SQL statement and use the special Copy function!

Setting Method: Right click --> Special Copy

6. Custom shortcut keys

PLSQL Developer reserves a lot of keys for user customization, which is very high. Unlike the domineering Word, basically all the keys have predefined functions, and it is a headache to modify them. Generally, after you open PLSQL Developer, the most common task is to open SQL Window and Command Window. The Shortcut Keys ALT + S and ALT + C are defined for these two operations, in this way, you only need to press the key to take the mouse three times.

Setting Method: menu Tools> Preferences> Key Configuration

7. automatically select a statement based on the cursor position in the SQL Window

Setting Method: Preferences --> Window Types --> SQL Window. Select AutoSelect statement. Note that each statement must be followed by a plus sign.

8. automatic replacement

Quick SQL statement input, for example, input s, Press space, and automatically replace with SELECT; for example, input sf, Press space, and automatically replace with SELECT * FROM, which is very convenient, it saves a lot of time to write repeated SQL statements.

Setting Method: menu Tools> Preferences> Editor> AutoReplace. --> Edit

This section describes how to set the shortcut keys for Oracle Database PL/SQL. We hope this introduction will be helpful to you!

Related reading:

Rlwrap

SQLPLUS spool to dynamic Log File Name

Oracle SQLPLUS prompt settings

Accelerate SQL return by setting SQLPLUS ARRAYSIZE (row prefetch)