2012年7月4日
摘要:
Today, we find a problem that ORA-12154: TNS:could not resolve the connect identifier specified. i think many people meet the problem. but today we fi
阅读全文
posted @ 2012-07-04 16:35
子虚乌有
阅读(230)
推荐(0)
2012年6月29日
摘要:
In some case, we may want to drop user.so we can use this sql as follow: drop user username cascade; but if the user is connected, we can't drop it.so
阅读全文
posted @ 2012-06-29 17:04
子虚乌有
阅读(229)
推荐(0)
摘要:
select 'drop user "' || username || '" cascade; ' from dba_users WHERE username like 'name%'; sql server browser must start, if you want use remote sq
阅读全文
posted @ 2012-06-29 11:17
子虚乌有
阅读(219)
推荐(0)
2012年6月28日
摘要:
About oracle XE and client for oracle In my environment, there is client for oracle exists, so after i install oracle XE, there may problem happen.aft
阅读全文
posted @ 2012-06-28 17:02
子虚乌有
阅读(327)
推荐(0)
2012年6月21日
摘要:
select count(*) from (select * from ( select * from TestLoad.dbo.T_TestType where mid = 42) main_query)only supported Oracle, Sql server and Sybase(AS
阅读全文
posted @ 2012-06-21 17:11
子虚乌有
阅读(1245)
推荐(0)
2012年5月29日
摘要:
//for delphi security install package[Fatal Error] Required package 'madSecurity_' not foundhttp://www.madshi.net/olddlp7.htm learn procedure procedur
阅读全文
posted @ 2012-05-29 14:29
子虚乌有
阅读(183)
推荐(0)
摘要:
program Project2;{$APPTYPE CONSOLE}uses SysUtils;type weekname = record chname:string; enname:string; end;const chnamearray: array[1..7]of string =('c
阅读全文
posted @ 2012-05-29 09:49
子虚乌有
阅读(164)
推荐(0)
2012年5月23日
摘要:
set oralcexe sa passwordorapwd file=PWDXE.ora password=iris entries=10 install sql 2008 ee version, need pwer shell in win2008 sp2down load power shel
阅读全文
posted @ 2012-05-23 14:22
子虚乌有
阅读(282)
推荐(0)
2012年5月22日
摘要:
For Sybase1.Down Load Address ; http://www.sybase.com/detail?id=1051287&elq=00000000000000000000000000000000ase157_winx64.zip 2.install and create Dat
阅读全文
posted @ 2012-05-22 15:03
子虚乌有
阅读(466)
推荐(0)
2012年3月12日
摘要:
Alter system set optimizer_features_enable='10.2.0.1'; Alter system set optimizer_features_enable='11.2.0.2';
阅读全文
posted @ 2012-03-12 17:06
子虚乌有
阅读(179)
推荐(0)