How to set shortcut keys for PL/SQL statements

Joke: when I first came into contact with the work of operation and maintenance, I sometimes saw some great gods come at hand with sql, and the speed of knocking on a complete sql was confusing. Later, I asked for advice and found that I could make full use of the shortcut keys of the PLSQL tool to improve efficiency. The following is a little summary of my own.

Description: when using PL/SQL, the commonly used sql statements are:

SELECT * FROM.

SELECT COUNT (*) FROM.

You can quickly output these two statements by setting keyboard shortcuts. Here are my own shortcut keys.

You can set it to "fast" as you like.

Sf = SELECT * FROM

Scf = SELECT COUNT (*) FROM

Settings: tool (Tool) è preferences (Preference) è user interface (User Interface)

è editor (editor) è automatic replacement (Auto replace) è editor (Edite)

Enter sf=select * from and scf=select count (*) from and save it.

Of course, the above settings are my own shortcut keys.

If you have any questions, please leave a message.