Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > PL/SQL下连接远程Oracle数据库

PL/SQL下连接远程Oracle数据库

WBOY
Release： 2016-06-07 17:29:15
Original
1068 people have browsed it

打开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中也适用。

linux

Related labels：
pl/sql
source：php.cn
Previous article：单机环境安装配置ASM实例 Next article：Oracle 全表扫描及其执行计划(full table scan)
Statement of this Website
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
Latest Articles by Author
Latest Issues
Illuminate\Database\QueryException: SQLSTATE: General error: 1364 Why can't I enter data? In the appointment table you don't want to enter the userid attrib...
From 2024-04-03 22:39:00
0
1
363
Unable to connect to SQL Server in Laravel I can't connect to sql-server in Laravel. I have given sqlserver configuration values ​​in...
From 2024-03-31 13:08:48
0
1
395
SQL Inner Join Performance Data Duplication table-->qtqstnId tag id1112232422 table-->question qid12 qid primary key, qstnId is ...
From 2024-03-30 09:17:19
0
1
397
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template