02 2013 档案

摘要：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 阅读全文

摘要：--动态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 阅读全文

摘要：网上查找资料，结合实际需要，过程如下建立监听：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 阅读全文