内存数据库

http://blog.youkuaiyun.com/kkdelta/article/details/7217761


dblink创建
http://blog.youkuaiyun.com/ruixj/article/details/3604325


创建和使用：
http://www.blogjava.net/fastzch/archive/2009/02/17/255175.html


删除job
查询：select * from dba_jobs;
删除： begin dbms_job.remove(jobno); end; commit;
jobno 为 job查询列表中的编号，删除后必须提交事务才能彻底删除。


Oracle存储过程

create or replace procedure p_get_users
is
id1 integer;
name1 varchar(20);
sex1 varchar(20);
count1 integer;

begin
select id,name,sex into id1,name1,sex1
from srpingtest;
dbms_output.put_line('编号'||id1||'修改后');
begin
select max(count) into count1 from spring_log;
exception
when others then
count1:=0;
end;
if count1 is null
then
count1:=1;
end if;
count1:=count1+1;
insert into spring_log values (sysdate,count1);
commit;
end p_get_users;


Oracle游标
create or replace procedure p_get_users2
is
id1 integer;
name1 varchar(20);
sex1 varchar(20);
cursor rc1 is select id,name,sex from srpingtest;
begin
open rc1;
loop
fetch rc1
into id1,name1,sex1;
exit when rc1%NOTFOUND;
dbms_output.put_line('编号'||id1);

end loop;

close rc1;
/* select id,name,sex into id1,name1,sex1
from srpingtest;*/


end p_get_users2;


oracle配置多个实例
http://blog.youkuaiyun.com/luiseradl/article/details/6972217


oracle查看连接
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN