for drop user username cascade
摘要：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
子虚乌有
阅读(226)
推荐(0) 编辑
Drop user cascade and start sql server browser
摘要：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
子虚乌有
阅读(217)
推荐(0) 编辑
Enviroment for Oracle_home& Path
摘要：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
子虚乌有
阅读(323)
推荐(0) 编辑
select syntax and ORA-01797
摘要：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
子虚乌有
阅读(1216)
推荐(0) 编辑
