- 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 "