PL/SQL statement Express input settings

Set the PL/SQL statement shortcut input method to make you a high-efficiency person.

1. Open PL/SQL, enter the user and log in

2. And open the Tools->preferences->editor->autoreplace-> select Enabled

3. Open Editor and enter the following setup statement:

　　

Sf=select * FROM

Scf=select Count (*) from

Df=delete from

S=select

F=from

W=where

D=delete

O=order by

U=update

Click Save when you are finished typing. Save sometimes will pop up the save location, follow the default path to continue to click Save.

4. Apply the shortcut syntax settings, first apply again OK.

5. Exit PL/SQL to re-login the input statement. Enter the shorthand statement set above, then press SPACEBAR or tab to complete automatically

Setup is complete, everyone hurry to try it!

PL/SQL statement Express input settings