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) 推荐(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) 推荐(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) 推荐(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) 推荐(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) 推荐(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) 推荐(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) 推荐(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) 推荐(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) 推荐(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) 推荐(0)