Oracle
CD2
这个作者很懒,什么都没留下…
展开
-
Oracle数据库常用操作 2011.3.15
1.创建DB Linkcreate database link link_nameconnect to username identified by passwordusing sqlnet_string;原创 2011-03-15 10:45:00 · 493 阅读 · 0 评论 -
NO_DATA_FOUND 与 %NOTFOUND的区别
<br />NO_DATA_FOUND异常只有当SELECT...INTO语句的WHERE没有匹配到数据是才出现。<br /> <br />当游标的WHERE子句不匹配任何数据时,%NOTFOUND被设置为TRUE。原创 2011-03-16 15:43:00 · 1092 阅读 · 0 评论 -
遍历游标的几种方式
遍历游标的几种方式原创 2011-03-16 15:09:00 · 2164 阅读 · 0 评论 -
数据库浅谈之触发器
CREATE OR REPLACE TRIGGER UpdateMajorStats AFTER INSERT OR DELETE OR UPDATE ON t_test_studentsDECLARE CURSOR c_Statistics IS SELECT major, COUNT(1) total_students, SUM(current_credits) total_credits FROM t_test_students GROUP BY major;BEGIN DELETE FR原创 2011-03-25 17:39:00 · 552 阅读 · 0 评论