摘要: 使用Oracle的DBMS_SQL包执行动态SQL语句引用自:http://blog.csdn.net/ggjjzhzz/archive/2005/10/17/507880.aspx引用自:http://www.cnblogs.com/simonhaninmelbourne/archive/2013... 阅读全文
posted @ 2015-01-13 11:09 随心随遇 阅读(542) 评论(0) 推荐(0)
摘要: sftp 是一个交互式文件传输程式。它类似于 ftp, 但它进行加密传输,比FTP有更高的安全性。下边就简单介绍一下如何远程连接主机,进行文件的上传和下载,以及一些相关操作。举例,如远程主机的 IP 是 202.206.64.33或者是域名www.hebust.edu.cn,用户名是 fyt ,在命... 阅读全文
posted @ 2014-09-09 14:28 随心随遇 阅读(343) 评论(0) 推荐(0)
摘要: CREATE ORREPLACE procedure chaifen ( v_dir varchar2, v_name varchar2, v_num number)as v_file_handle utl_file.file_type; v_count integer :=1;begin v_file_handle := utl_file.fopen(v_dir,v_name,'r'); --'r' 只读loop utl_file.fcopy (src_location =>v_dir, src_filename =>v_name, dest_lo 阅读全文
posted @ 2013-02-23 17:39 随心随遇 阅读(123) 评论(0) 推荐(0)
摘要: --动态SQLdeclaredml_stat varchar2(100):='delete from emp where empno=&eno returning ename into :name';v_name emp.ename%type;beginexecute immediate dml_stat returning into v_name;dbms_output.put_line(v_name||'kk');end;declarev_name emp.ename%type;beginexecute immediate 'delete f 阅读全文
posted @ 2013-02-23 11:21 随心随遇 阅读(125) 评论(0) 推荐(0)
摘要: 网上查找资料,结合实际需要,过程如下建立监听:fworcl =(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.8.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ))赋予权限:grant PUBLIC DATABASE LINK to scott;grant DATABASE LINK to scott;建立链接:CREATE PUBLIC DATABASE LINK fworcl CONNECT TO scott IDENTIFI 阅读全文
posted @ 2013-02-23 11:10 随心随遇 阅读(138) 评论(0) 推荐(0)
摘要: Oracle UTL_FILE 用法例子General Information Note: O/S permissions are those of the user 'Oracle' ... not the schema owner or connected userSource{ORACLE_HOME}/rdbms/admin/utlfile.sqlFirst Availability7.3.4init.ora Parametersutl_file_dirutl_file_dir=c:/oraload utl_file_dir=c:/temp utl_file_dir=*O 阅读全文
posted @ 2012-11-22 20:30 随心随遇 阅读(878) 评论(0) 推荐(0)
摘要: 全面学习DBMS包之DBMS_SQL引用: http://www.cnblogs.com/zeromyth/archive/2009/09/29/1576627.html在PL/SQL编程当中,经常会遇到一些需要动态处理数据或表结构的问题,比如对一批表里的数据进行处理,或者批量创建表,索引,触发器等... 阅读全文
posted @ 2012-11-08 21:46 随心随遇 阅读(182) 评论(0) 推荐(0)
摘要: 无 阅读全文
posted @ 2012-11-08 21:41 随心随遇 阅读(68) 评论(0) 推荐(0)