- 博客(7)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 没有难度却繁琐的一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
667
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
850
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
687
原创 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
1028
原创 Oracle高水位标志（high-water mark）相关概念
<br />Oracle高水位标志: high-water mark<br />可以用以下几点对high-water mark进行理解<br />1.指一个表中曾经被用过的最后一个块<br />2.如果有数据被插入表，high-water mark 就移到到被使用的最后一个块<br />3.如果有数据被删除，high-water mark的位置不会变<br />4.high-water mark被储存在表的段头(segment header of the table)<br />5.当对表执行全
2010-11-10 15:28:00
1773
原创 Love Paradise
You're always on my mind All day just all the time You're everything to me Brightest star to let me see You touch me in my dreams We kiss in every scene I pray to be with you through rain and shiny days I'll love you Till I die Deep as sea Wide as
2010-10-20 12:57:00
635
原创 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
1008
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人