内存数据库

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

相关推荐