oracle sql
select tbl_OFFDBSPACE.OFFICENAME,tbl_OFFDBSPACE.DBNAME,tbl_OFFDBSPACE.TABLESPACENAME,tbl_OFFDBSPACE.OFFICEDBNAME,
tbl_OFFDBSPACE.OFFICEDBTABNAME,time10,AVG_TABSPACEUSAGE,MAX_TABSPACEUSAGE,MIN_TABSPACEUSAGE
from (select NMSGUEST.NBBamTabEx.DEVIPADDR as DEVIPADDR,NMSGUEST.NBBamTabEx.OFFICENAME as OFFICENAME,
NMSGUEST.DB2INFO.DBNAME as DBNAME,NMSGUEST.DB2TABLESPACE.TABLESPACENAME as TABLESPACENAME,
NMSGUEST.DB2INFO.DBINDEX as DBINDEX,NMSGUEST.DB2TABLESPACE.TABLESPACEINDEX as TABLESPACEINDEX,
NMSGUEST.NBBamTabEx.OFFICENAME ||'|'|| NMSGUEST.DB2INFO.DBNAME as OFFICEDBNAME,
NMSGUEST.NBBamTabEx.OFFICENAME ||'|'|| NMSGUEST.DB2INFO.DBNAME ||'|'|| NMSGUEST.DB2TABLESPACE.TABLESPACENAME as OFFICEDBTABNAME
from NMSGUEST.NBBamTabEx,NMSGUEST.DB2INFO,NMSGUEST.DB2TABLESPACE
where NMSGUEST.NBBamTabEx.DEVIPADDR=NMSGUEST.DB2INFO.DEVIPADDR and NMSGUEST.NBBamTabEx.DEVIPADDR=NMSGUEST.DB2TABLESPACE.DEVIPADDR) tbl_OFFDBSPACE,
(select devid,HWDB2DATABASEID,HWDB2TBSID,round(avg(TABSPACEUSAGE),4) as AVG_TABSPACEUSAGE,
round(max(TABSPACEUSAGE),4) as MAX_TABSPACEUSAGE,roun
相关问答：
环境：1.win2003server+oracle9i
2.oracle9i字符集为AMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer版本 1.5.5
现象描述: 1.在sql developer 中查询oracle中的某个表，中文全部显示为乱码。
......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
3-5人，工作地点上海浦东软件园，2-3年经验，英文流利，有意者请联系38954510-1355，15821699737，y.ming@live.cn
自己顶。。。
没有ORACLE ERP的经验,有用友和TIPTOP经验,英语说不好,看还是可以!
不知道有没有 ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
然後按回車鍵 說明: user/password@dbname 分別表示用戶名，密碼和服務名 f ......
