内存数据库

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   *   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.csdn.net/luiseradl/article/details/6972217




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