“/”是什么意思?在 PL/SQL 中做什么?
我查看了一些 PL/SQL 代码,并在脚本中遇到了以下内容:
/
SHOW error
grant execute on someName1 to someName2;
/
SHOW error
查看 PL/SQL 的文档 我找不到 / 的作用的解释。
谁能启发我吗?
- 更新:我在 SQL Developer for Mac 中打开了包含此脚本的文件。编译它给出错误“遇到符号'/'”。这些斜杠应该被删除吗?
I reviewing some PL/SQL code and I came across the following in the scripts:
/
SHOW error
grant execute on someName1 to someName2;
/
SHOW error
Reviewing the documentation for PL/SQL I could not find an explanation what the /'s do.
Can anyone enlighten me?
- Update: I opened the file that includes this script in SQL Developer for Mac. Compiling it gives the error "encountered the symbol '/'". Should these slashes be removed?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
“/”执行当前缓冲区中的sql命令。类似于SQL Server的GO
"/" executes the sql command in the current buffer. It similar to GO of SQL Server
斜杠基本上执行缓冲区中存储的最新命令。
这是一件笨重的事情,但是许多 PL/SQL 解释器/引擎(例如 SQL Plus)要求您在每个完整语句后输入“/”才能实际执行它并查看结果。
http://download.oracle.com/docs /cd/B28359_01/server.111/b31189/ch12004.htm#SQPUG162
The slash basically executes the latest command stored in the buffer.
It's kind of a clunky thing, but a lot of PL/SQL interpreters/engines like SQL Plus require you to enter a "/" after every complete statement to actually execute it and see the results.
http://download.oracle.com/docs/cd/B28359_01/server.111/b31189/ch12004.htm#SQPUG162