如何在oracle中使用这些sql脚本？
我有一个像这样的sql脚本：
@tables\run.sql;
@sequences\run.sql;
@views\run.sql;
@functions\run.sql;
@procedures\run.sql;
我有两个问题：
- 我是否需要将所有相关的脚本文件暗示到数据库中？
- 我在PL/SQL Developer中执行上面的SQL脚本，但不幸的是它提示
ORA-00900问题。为什么会这样呢？
I have a sql-script like:
@tables\run.sql;
@sequences\run.sql;
@views\run.sql;
@functions\run.sql;
@procedures\run.sql;
And I have two questions:
- Do I need to imply all the related script-files into the db?
- I execute the SQL script above in the PL/SQL developer but unfortunately it prompts
ORA-00900problem. Why so?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您指示的sql脚本正在尝试运行它希望在这样的目录结构中找到的其他几个sql脚本
您没有提到您是在Windows机器上还是在unix/linux上。如果您使用的是 unix/linux，通常您会使用 sqlplus 命令行从包含顶层 run.sql（包含上面列出的命令的目录）的目录中运行此脚本。
PLSQL Developer 将在 Windows 上运行，因此我假设它将使用在 Windows 属性上设置为“位置”的目录，用于启动 PLSQL Developer（可能类似于 c:\Program Files\plsqldev 作为默认值，以便找到脚本，它会期望子目录（过程/表/视图/序列等..）位于该目录下，
您将需要所有脚本并将子目录结构保留在 plsql Developer 所在的 Windows 客户端计算机上。或在 Oracle 数据库所在的数据库服务器上运行，以便运行上面指定的脚本。
The sql script you indicate is trying to run several other sql scripts it expects to find in a directory structure like this
You dont mention if you are on a windows machine or unix/linux. If you are on unix/linux, normally you would use the sqlplus command line to run this script from the directory containing the top level run.sql (the one containing the commands you listed above).
PLSQL developer will run on windows so I assume it will use whichever directory is set as the "location" on the windows properties that you use to start plsql developer (probably something like c:\Program Files\plsqldev as a default so to find the scripts, it would expect the subdirectories (procedures/tables/view/sequences etc..) to be under that directory.
You will need all the scripts and to keep the subdirectory structure on either your windows client machine where plsql developer is running or on the database server where the Oracle database resides in order to run the script you have indicated above.
PLSQL Developer 的魅力之一是它有许多不同类型的窗口，可以执行不同的操作。听起来您正尝试在 SQL 窗口中运行此脚本。在命令窗口中运行它相反，它基本上是一个 SQL*Plus 模拟器。
One of the, er, charms of PLSQL Developer is that it has many different types of windows which can do different things. It sounds like you are trying to run this script in a SQL window. Run it in a Command window instead, which is basically a SQL*Plus emulator.