摘要： 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 阅读全文

摘要： 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 阅读全文

摘要： select 'drop user "' || username || '" cascade; ' from dba_users WHERE username like 'name%'; sql server browser must start, if you want use remote sq 阅读全文

摘要： 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 阅读全文

摘要： select count(*) from (select * from ( select * from TestLoad.dbo.T_TestType where mid = 42) main_query)only supported Oracle, Sql server and Sybase(AS 阅读全文

摘要： //for delphi security install package[Fatal Error] Required package 'madSecurity_' not foundhttp://www.madshi.net/olddlp7.htm learn procedure procedur 阅读全文

摘要： program Project2;{$APPTYPE CONSOLE}uses SysUtils;type weekname = record chname:string; enname:string; end;const chnamearray: array[1..7]of string =('c 阅读全文

摘要： 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 阅读全文

摘要： For Sybase1.Down Load Address ; http://www.sybase.com/detail?id=1051287&elq=00000000000000000000000000000000ase157_winx64.zip 2.install and create Dat 阅读全文

摘要： Alter system set optimizer_features_enable='10.2.0.1'; Alter system set optimizer_features_enable='11.2.0.2'; 阅读全文