running sql script from remote machine by sqlplus
在Tanel的培训中看到，sqlplus的@可以通过http调用远程机器上的sql文件本地执行。Sqlplus太神奇了。
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 19 23:42:54 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> set echo onSQL> @http://www.yumianfeilong.com/helloworld.sql
SQL> select sysdate from dual;SYSDATE
—————
19-DEC-08
这样可以将script脚本集中管理，并且远程调用。
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到 POCO 网摘"){kind=logo}
