-
编辑 删除
转贴msn messenger 80048802解决办法
http://oldwain.itpub.net/post/6/222030also see:http://messenger-support.spaces.live.com/Blog/cns!1pUFzGgzjAV-OT0jri_AqaGw!1070.entry
-
编辑 删除
第一次见到这么长的SQL语句
来自一个ERP系统,运行时间越为5分钟,但用户希望是10秒以内.不过还是很佩服作者的,过几天才有时间考虑 .SELECT X.ORGANIZATION_CODE, X.compeq_lot_num real_lot_num, &n...
-
编辑 删除
oracle8i的新特性
来自网友1Internet计算 Java 1.1 ● WebDB，用于建立、部署和监视Web应用1.2 ● iMedia1.3 ● OracleInternet文件系统 ● 数据库中的JavaVM1.4 ● Java存储过程、函数和触发器1.5 ● 在Java、SQL...
-
编辑 删除
Logging using autonomous transactions[akadia]
At times, you may want to commit or roll back some changes to a table independently of a primary transaction's final outcome. For example, while running a transaction, you may want to log error messag...
-
编辑 删除
Patch 4658188
用来解决oracle9207 for rac 关于ksu process alloc latch yield的一个bug.
-
编辑 删除
太阳系起源和演化
http://tech.163.com/04/1031/15/141HLSUV0009rt.html太阳亘古不变还是有始有终？它的来龙去脉究竟如何？ 实际上，任何天体都和人一样，要经历出生、成长、死亡的过程，这就是天体的演化过程。人...
-
编辑 删除
拷贝lx5035c.nlb时出错
在windows2003上安装ora8i,oracle9i数据库代码时，报以上错误。后来又换了一个oracle9i安装盘，看来是安装文件有问题。
-
编辑 删除
ora-24324 ora-24323 ora-28547
在建库时遇到这个错误:ORA-24324: service handle not initializedORA-24323: value not allowedORA-28547: connection to server failed, probable Oracle Net admin error解决方法：注销sqlnet.ora 文件里的以下行...
-
编辑 删除
The mystery of Stored Outlines[akadia]
Where to use Stored Outlines ?The SQL statements in a hybrid system need to have an execution plan that is appropriately tailored for the type of system configuration you are using. When running the s...
-
编辑 删除
C群流行性脑膜炎
安徽11市发生流脑疫情 60多人感染8人死亡此次流行的新型C群流行性脑膜炎，系C群脑膜炎双球菌传播导致。这一群种是我国近年来新发现报告的菌群，与过去常见的A群流脑相比，C群流脑具有易传播、隐性感染比例高、起病急...
-
编辑 删除
Show Table and System Privileges[akadia]
It is normally difficult to list all privileges and roles assigned to a specific user in one select, since a privilege can be assigned to a role, which can be assigned to another role, which in turn c...
-
编辑 删除
如何将xml格式的数据导入oracle里
1.在oracle建好表2.用excel打开xml文档,进行格式的修改3.用toad导入表中4.写过程将数据更新到相应的表中
-
编辑 删除
一个和控制文件有关的问题
--一个开发数据库，启动报错：Mon Nov 27 15:10:02 2006Database mounted in Exclusive Mode.Completed: ALTER DATABASE MOUNTMon Nov 27 15:10:02 2006ALTER DATABASE OPENMon Nov 27 15:10:02 2006Rolling back ...
-
编辑 删除
exec(): 0509-036 Cannot load program onstat because of the following errors
在sqlplus username/passwd时遇到以下错误：exec(): 0509-036 Cannot load program onstat because of the following errors: 0509-130 Symbol resolution failed for /usr/lib/threads/libc.a[aio_64.o]beca...
-
编辑 删除
ORA-12704: character set mismatch
在utf8数据库里编译存储过程，遇到这个问题.oracle9206sql: [做了简化]select a from t1union allselect '1' from t2;其中t1.a是nvarchar2类型。解决办法很简单:select a from t1union allselect N'1' from t2;...
-
编辑 删除
How to select the one column per row in display?
从网上找到的一个脚本,自己改了改.create or replace procedure print_table(qry in varchar2)asq_cursor integer; column_val &nbs...
-
编辑 删除
奇怪，山大网站上竟然没有报道王小云等人的工作
实在不明白，难道是刚开学的原因？还是别的什么原因？
-
编辑 删除
ORA-00600 [qctstc2o1]
from metalink;Note: For additional ORA-600 related information please read Note 146580.1PURPOSE: This article discusses the internal error "ORA-600 [qctstc2o1]", what it means and possible...
-
编辑 删除
Logon DB Trigger to Setup the User Environment[akadia]
Date and time format settings are based on the user's locale and native language. For example, SCOTT needs default NLS_DATE_FORMAT "MM/DD/YYYY", and ZAHN needs default "DD-MON-YYYY".,etc. The idea is ...
-
编辑 删除
一个查看oracle最新漏洞的网址
http://www.oracle.com/technology//deploy/security/alerts.htm
