Oracle- (自动替换）

1. open pl/sql, click "Tools" >>Preferences

            

 

       2. find "User Interface" module, click "editor".

           

      3. prepare a txt file as below: 

          

       4. Drag the zip code scroll bar with the mouse, find the "auto replace" module, "Enabled" and choose the file you have created.

           

          5. replace the file , click "Apply" &"Save" .

          6. Then in Edit page ,

            Input "sf" and press "Space" key, then will auto replace to "select * from"

            Input "sr" and press "Space" key, then will auto replace to "select t.*,t.rowid from "