Oracle/PLSQL: Execute an SQL script file in SQLPlus
来源:互联网 发布:python正态分布随机数 编辑:程序博客网 时间:2024/05/17 08:25
Question: How do I execute an SQL script file in SQLPlus?
Answer: To execute a script file in SQLPlus, type @ and then the file name.
SQL > @{file}
For example, if your file was called script.sql, you'd type the following command at the SQL prompt:
SQL > @script.sql
The above command assumes that the file is in the current directory. (ie: the current directory is usually the directory that you were located in before you launched SQLPlus.)
If you need to execute a script file that is not in the current directory, you would type:
SQL > @{path}{file}
For example:
SQL > @/oracle/scripts/script.sql
This command would run a script file called script.sql that was located in the /oracle/scripts directory.
引文来源 Oracle/PLSQL: Execute an SQL script file in SQLPlus
- Oracle/PLSQL: Execute an SQL script file in SQLPlus
- how to execute sql script in c#
- Oracle/PLSQL: Execute a function that is defined in a package
- How to execute shell script in Java?
- Oracle Script-Shell调用SQLplus输出结果
- How to execute an OS command in SQL*PLUS without leaving the session ?
- Oracle Script-GetHparDes.sql
- Oracle-script-ShowEvents.sql
- Oracle Script-ShowSessionWait.sql
- compile and execute cpp file in ubuntu
- SQL Script for read information from a csv file in FTP Server
- oracle sqlplus执行sql文件
- oracle sqlplus执行sql文件
- oracle sqlplus执行sql文件
- Oracle maintain sql & sqlplus tools
- oracle sqlplus执行sql文件
- Oracle-sqlplus导入sql文件
- oracle sqlplus执行sql文件
- Python操作Oracle数据库
- 为libjingle项目创建vs solution
- ubuntu切换root用户
- 黑马程序员java高新技术篇----类加载与注解
- 使用Eclipse调试Java程序的10个技巧
- Oracle/PLSQL: Execute an SQL script file in SQLPlus
- Ubuntu environment 修改后,解决办法
- 浅谈游戏的微博营销
- Windows服务程序图文教程
- 文摘--用rp-pppoe做了个pppoe-server
- group by 在sqlserver与oracle中的差别
- C++代码评审(Code Review)等级标准
- 微信绝对不收费
- extern "C"的用意