Autoreplace & Templates stuff - 04/11/18 01:15 PM
Hello everyone. I have some questions about autoreplace and templates in PLSQL Developer.
1. Is it possible to assign special key to invoke autoreplaced text?
Now regular string in file autoreplace.txt is looking like:
se = SELECT
de = DELETE
...
etc
It's quite simple and good but we can have troubles when using aliases, like that:
SELECT * FROM special_environment se WHERE se.*** = ***
Instead of alias "se" we will take "SELECT" word.
Now i'am using symbol "~" because it's not used in SQL-syntax and i can't suddenly break my query (unlike of *, !, @, $, etc) but it's not comfortable to press shift+` to draw this character.
I think it's pretty idea to tell your program what key should be as "trigger". For example:
se%TAB% = SELECT
i.e. we typing se, pressing TAB (or any key we want, like: F1, Alt, etc) and "se" turning in "SELECT" and so on...
Btw, what about autocomplete ability by pressing TAB on commands like SELECT, DELETE, DROP, FROM, etc? Mainly it's useful in command window, but in SQL- and Test- windows it would very helpful too (we don't need to make additional autoreplace rules). For people who don't want to use this ability it could be switched off in Settings.
Maybe i'am blind and didn't noticed that in program settings (tried to find it in v11 and v12)?
2. Can anyone tall me where i can find full template syntax (old & new)?
Google and user's guide doesn't help, all i can find is a couple of examples from trouble-topics here
Thanks!
1. Is it possible to assign special key to invoke autoreplaced text?
Now regular string in file autoreplace.txt is looking like:
se = SELECT
de = DELETE
...
etc
It's quite simple and good but we can have troubles when using aliases, like that:
SELECT * FROM special_environment se WHERE se.*** = ***
Instead of alias "se" we will take "SELECT" word.
Now i'am using symbol "~" because it's not used in SQL-syntax and i can't suddenly break my query (unlike of *, !, @, $, etc) but it's not comfortable to press shift+` to draw this character.
I think it's pretty idea to tell your program what key should be as "trigger". For example:
se%TAB% = SELECT
i.e. we typing se, pressing TAB (or any key we want, like: F1, Alt, etc) and "se" turning in "SELECT" and so on...
Btw, what about autocomplete ability by pressing TAB on commands like SELECT, DELETE, DROP, FROM, etc? Mainly it's useful in command window, but in SQL- and Test- windows it would very helpful too (we don't need to make additional autoreplace rules). For people who don't want to use this ability it could be switched off in Settings.
Maybe i'am blind and didn't noticed that in program settings (tried to find it in v11 and v12)?
2. Can anyone tall me where i can find full template syntax (old & new)?
Google and user's guide doesn't help, all i can find is a couple of examples from trouble-topics here
Thanks!