oracle 安装和运行 Pl/SQL 包
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4673174/
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
Installing and running Pl/SQL packages
提问by x.509
I have the package.pkg and package.pkg files, how can i install and run it without using Pl/SQL Developer? is there anyway or i have to install Pl/SQL Developer?
我有 package.pkg 和 package.pkg 文件，如何在不使用 Pl/SQL Developer 的情况下安装和运行它？无论如何还是我必须安装 Pl/SQL Developer？
回答by winkbrace
Or in sql*plus (which is installed together with Oracle) you type @/path/to/package.pkg. Make sure to end with a / (forward slash).
或者在 sql*plus（与 Oracle 一起安装）中键入 @/path/to/package.pkg。确保以 /（正斜杠）结尾。
It should look something like this:
它应该是这样的：
SQL> @proc.prc
SQL> CREATE OR REPLACE PROCEDURE PROC(VAL1 IN NUMBER, VAL2 OUT NUMBER)
2 AS
3 BEGIN
4 VAL2 := VAL1*2;
5 END PROC;
6 /
Procedure created.
回答by Harrison
Oracle Developer is free and is produced by Oracle
Oracle Developer 是免费的，由 Oracle 制作
http://www.oracle.com/technetwork/developer-tools/sql-developer/index.html
http://www.oracle.com/technetwork/developer-tools/sql-developer/index.html
as mentioned elsewhere, SQLPlus is available if you have the oracle client installed.
正如其他地方所提到的，如果您安装了 oracle 客户端，则可以使用 SQLPlus。
you can also look into http://www.orafaq.com/wiki/ISQLPlusif it installed on by the dbas
你也可以查看http://www.orafaq.com/wiki/ISQLPlus如果它是由 dbas 安装的
回答by Allan
Package scripts are just text, so any SQL interface will work. The obvious choice is SQL*Plus, the text-based interface that is part of the full Oracle client installation.
包脚本只是文本，因此任何 SQL 接口都可以使用。显而易见的选择是 SQL*Plus，它是基于文本的界面，它是完整 Oracle 客户端安装的一部分。
