- 博客(7)
- 资源 (2)
- 收藏
- 关注
原创 没有难度却繁琐的一trigger
<br />CREATE OR REPLACE TRIGGER BI_M_OUT_HITEM<br /> INSTEAD OF INSERT OR UPDATE OR DELETE ON M_OUT_HITEM REFERENCES OLD AS OLD NEW AS NEW<br /> FOR EACH ROW<br />DECLARE<br /> v_boxstatus NUMBER(10);<br /> v_isb
2011-03-03 13:57:00 587 1
原创 Today I will be master of my emotions.
<br />Today I will be master of my emotions. <br />The tides advance; the tides recede. Winter goes and summer comes. summer wanes and the cold increases. The sun rises; the sun sets. The moon is full; the moon is black. The birds arrive;the birds depart
2010-11-29 14:48:00 732 1
原创 RMAN中常用的命令
<br />1、连接到目标数据库(不用恢复目录数据库):<br /> Rman nocatalog target sys/change_on_isntall@testdb<br /> Rman catalog rman_user/rman_user@ora9rc target sys/change_on_install@testdb<br />2、SHOW命令:<br /> 显示rman配置: RMAN> show all;<br />3、REPORT命令:
2010-11-29 14:35:00 594
原创 oracledbconsole--em无法启动
<br />Microsoft Windows [版本 6.1.7600]<br />版权所有 (c) 2009 Microsoft Corporation。保留所有权利。<br /><br />C:/Users/Administrator>emca<br />d:/oracle/product/10.2.0/db_1/bin/emca.bat [操作] [模式] [数据库类型] [标记] [参<br />数]<br /><br />-h | --h | -help | --help:
2010-11-25 13:10:00 937
原创 Oracle高水位标志(high-water mark)相关概念
<br />Oracle高水位标志: high-water mark<br />可以用以下几点对high-water mark进行理解<br />1.指一个表中曾经被用过的最后一个块<br />2.如果有数据被插入表,high-watermark 就移到到被使用的最后一个块<br />3.如果有数据被删除,high-watermark的位置不会变<br />4.high-water mark被储存在表的段头(segment header of the table)<br />5.当对表执行全
2010-11-10 15:28:00 1558
原创 Love Paradise
You're always on my mindAll day just all the timeYou're everything to meBrightest star to let me seeYou touch me in my dreamsWe kiss in every sceneI pray to be with youthrough rain and shiny daysI'll love you Till I dieDeep as sea Wide as
2010-10-20 12:57:00 528
原创 good good study day day up
1.按姓氏笔画排序:Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 2.数据库加密:select encrypt(原始密码)select pwdencrypt(原始密码)select pwdcompare(原始密码,加密后密码) = 1--相同;否则不相同 encry
2009-11-04 09:06:00 923
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人