luxuheng 2012-08-10
http://blog.csdn.net/kkdelta/article/details/7217761
dblink创建
http://blog.csdn.net/ruixj/article/details/3604325
创建和使用:
http://www.blogjava.net/fastzch/archive/2009/02/17/255175.html
删除job
查询:select*fromdba_jobs;
删除:begindbms_job.remove(jobno);end;commit;
jobno为job查询列表中的编号,删除后必须提交事务才能彻底删除。
Oracle存储过程
createorreplaceprocedurep_get_users
is
id1integer;
name1varchar(20);
sex1varchar(20);
count1integer;
begin
selectid,name,sexintoid1,name1,sex1
fromsrpingtest;
dbms_output.put_line('编号'||id1||'修改后');
begin
selectmax(count)intocount1fromspring_log;
exception
whenothersthen
count1:=0;
end;
ifcount1isnull
then
count1:=1;
endif;
count1:=count1+1;
insertintospring_logvalues(sysdate,count1);
commit;
endp_get_users;
Oracle游标
createorreplaceprocedurep_get_users2
is
id1integer;
name1varchar(20);
sex1varchar(20);
cursorrc1isselectid,name,sexfromsrpingtest;
begin
openrc1;
loop
fetchrc1
intoid1,name1,sex1;
exitwhenrc1%NOTFOUND;
dbms_output.put_line('编号'||id1);
endloop;
closerc1;
/*selectid,name,sexintoid1,name1,sex1
fromsrpingtest;*/
endp_get_users2;
oracle配置多个实例
http://blog.csdn.net/luiseradl/article/details/6972217
oracle查看连接
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN