是否存在用于编写"SELECT * FROM"消息的键盘快捷键?模板? [英] Is there a keyboard shortcut for writing "SELECT * FROM" template?

问题描述

是否可以通过PL/SQL Developer中的某个键盘快捷键或其他类似工具在SQL编辑器中生成SELECT * FROM模板?

Is there a way to generate a SELECT * FROM template in SQL editor by a certain keyboard shortcut in PL/SQL Developer or another similar tool ?

使用这样的键盘快捷键可以节省编写此重复语句所需的时间.

It would be great to save the time needed to write this repetitive statement with such keyboard shortcut.

推荐答案

我们可以为经常使用的单词设置一些快捷方式.例如，我们可以键入s，然后按空格键，字母s将替换为SELECT，另一个示例，键入sf并单击空格键，它将替换为select * from. 这确实节省了很多时间，而不必一次又一次地编写这些语句.

We can set up some shortcuts for there regularly used words. For example, we can type s, and pressing the space bar, the letter s will be replaced with SELECT and another example, type sf and hit space bar, it will be replaced with select * from. This really saves a lot of time instead of writing these statements again and again.

要执行此操作:转到工具->首选项->编辑器->自动替换->单击编辑

To do this: Go to Tools -> Preferences -> Editor -> autoreplace -> Click Edit

在弹出框中，键入以下定义:

In the pop up box, type the following definitions:

s = SELECT
f = FROM
w = WHERE
o = ORDER BY
d = DELETE
sf = SELECT * FROM
df = DELETE FROM
SC = SELECT COUNT (*) FROM

，然后将AutoReplace.txt文件保存在所需的任何位置.点击应用"，继续尝试使用它们.

and save the AutoReplace.txt file, wherever you want. Click Apply and go ahead trying to use them.

如果要编辑/添加/删除上面定义的某些快捷方式，请从工具"菜单执行相同的步骤，直到单击应用"按钮.

If you want to edit/add/delete some of the above defined shortcuts, perform the same procedure from the Tools menu until clicking the Apply button.

希望这对您有所帮助.

这篇关于是否存在用于编写"SELECT * FROM"消息的键盘快捷键?模板?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！