Oracle
zhiwen_huang
这个作者很懒,什么都没留下…
展开
-
OracleのDB作成エラーの解決方法
oracle/ora92/network/admin/sqlnet.oraには、SQLNET.AUTHENTICATION_SERVICES= (NTS)をSQLNET.AUTHENTICATION_SERVICES= (NONE)に修正してください。原创 2004-11-08 17:35:00 · 806 阅读 · 0 评论 -
Oracleのexp & imp
sql.txtファイルの内容:drop user newuser cascade;create user newuser identified by newuser;grant connect to newuser;grant resource to newuser;grant dba to newuser;exit;exdb.batファイルの内容:exp olduser/olduser@from原创 2004-11-09 08:18:00 · 809 阅读 · 0 评论 -
Oracle with语句示例
Oracle with语句示例WITH a AS (SELECT * FROM bd_member WHERE ROWNUMb AS (SELECT * FROM tp_trade_card)select A.MEMBER_NAME,B.CARD_NOfrom A,Bwhere A.BD_MEMBER_ID = B.BD_MEMBER_ID原创 2006-07-07 17:55:00 · 1556 阅读 · 0 评论