连接到远程数据库:
连接语法:conn user/pwd@hostIP/SID (username/password@172.19.151.21/orcl)
下面是我测试的例子:
SQL> conn school/school@192.168.10.41/syntong
已连接。
SQL> select localsn,account 交易金额 from posfee;
LOCALSN 交易金额
---------- --------------------
156 1200
156 1200
156 1200
156 1200
23 123
155 1200
156 1200
0 1200
0 1200
0 1200
0 1200
LOCALSN 交易金额
---------- --------------------
0 1200
0 1200
157 1200
157 1200
158 1200
159 1200
160 1200
172 1200
173 1200
174 1200
已选择21行。
SQL> disconn;
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
SQL>