oracle 在 sqldeveloper 中运行其他脚本的脚本
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/1367406/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Script to run other scripts in sqldeveloper
提问by chris
I have a number of scripts used to build a database. These need to be executed in a certain order. Is it possible to create a script to run other scripts in SQL Developer (1.5.3)?
我有许多用于构建数据库的脚本。这些需要按特定顺序执行。是否可以在 SQL Developer (1.5.3) 中创建一个脚本来运行其他脚本?
I know I can do this with sqlplus, but I was hoping there's a similar ability I just don't know about.
我知道我可以用 sqlplus 做到这一点,但我希望有一种我不知道的类似能力。
回答by Vincent Malgrat
The SQL*Plus synthax works (with run script
):
SQL*Plus 合成器工作(使用run script
):
@script arg1 arg2 ... argn
or
或者
@"/path/to/directory/script" arg1 arg2 ... argn
回答by skaffman
SqlDeveloper should be able to use the same syntax as SqlPlus, i.e.
SqlDeveloper 应该能够使用与 SqlPlus 相同的语法,即
@@ script1
@@ script2
@@ script3
This will execute script1.sql
, script2.sql
and script3.sql
in order.
这将执行script1.sql
,script2.sql
而script3.sql
为了。