PL/SQL下连接远程Oracle数据库
- WBOYOriginal
- 2016-06-07 17:29:151047browse
打开PL/SQL的Command Window，输入SQL语句，SQL语句的语法： conn user/pwd@hostIP/SID 例如： conn scott/tiger@192.168.150.30
打开PL/SQL的Command Window，输入SQL语句，，SQL语句的语法：
conn user/pwd@hostIP/SID
例如：
conn scott/tiger@192.168.150.30/orcl
如果需要改回连接本地Oracle数据库，则把对应的ip改成127.0.0.1即可。
此方法在SQL/PLUS中也适用。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：单机环境安装配置ASM实例Next article：Oracle 全表扫描及其执行计划(full table scan)