PL/SQL Developer automatic completion

quick Input SQL statement, such as input s, press the space, automatically replace the select; For example, enter SE, press space,

It is convenient to replace the select * from automatically, saving a lot of time to write duplicate SQL statements.

Setup method: Menu tools–> preferences–> editor–> autoreplace–> Edit

Clicking Save will automatically generate the AutoReplace.txt file and save it to the specified location.

The following defines some rules as a reference

S=selectse=select * Fromf=fromw=where

PS: Enter one per line, which is a rule

Itmyhome

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

PL/SQL Developer automatic completion