imported>DrOwl mNo edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
[http://www.excce.com 中国涂装设备网][http://www.hzn.cn/web/ 网站建设�?�州][http://www.hzn.cn/domain/ �?�州域�??注册][http://www.hzn.cn/email/ �?�州�?业邮局][http://www.hzn.cn/tj/ �?�州网站网络推广][http://www.51122.com/coating/ 涂装] |
|||
you can use sql to access Concord's database |
|||
[http://www.51122.com 世纪网�?�之家] |
|||
[http://go.excce.com 网站建设] |
|||
[http://www.uusky.com 世纪情感] |
|||
first use the "sqlplus" command to open the SQL commandline interface |
|||
[http://www.uusky.org �?�州网络公�?�] |
|||
*<pre> host# sqlplus user/pass </pre> |
|||
[http://www.uusky.net �?�州喷塑加工] |
|||
you can turn off the table headers (this is usefull if you are scripting)<br> |
|||
increase the number of pages / lines in each page. |
|||
*<pre>SQL>SQL> set pages 100 lines 1000 head off |
|||
SQL> |
|||
</pre> |
|||
[http://www.hzn.cn �?�州网站建设] |
|||
you can use the DESCRIBE command to find detales about tables eg: |
|||
[http://www.hzn.cn �?�州网络公�?�] |
|||
*<pre>SQL> DESCRIBE NH_GROUP; |
|||
[http://www.uusky.com/ 情感] |
|||
Name Null? Type |
|||
[http://www.uusky.org �?�州网站建设] |
|||
----------------------------------------- -------- ---------------------------- |
|||
[http://www.znpp.com �?�州网站建设] |
|||
GROUP_ID NOT NULL NUMBER(11) |
|||
GROUP_TYPE NOT NULL NUMBER(11) |
|||
MACHINE_ID NOT NULL NUMBER(11) |
|||
CREATE_TIME NOT NULL NUMBER(11) |
|||
MODIFY_TIME NOT NULL NUMBER(11) |
|||
NAME NOT NULL VARCHAR2(64) |
|||
CONTAINER_TYPE NOT NULL NUMBER(11) |
|||
EXPIRE_TIME NOT NULL NUMBER(11)</pre> |
|||
*<pre>SQL> DESCRIBE NH_ELEMENT; |
|||
Name Null? Type |
|||
----------------------------------------- -------- ---------------------------- |
|||
ELEMENT_ID NOT NULL NUMBER(11) |
|||
MACHINE_ID NUMBER(11) |
|||
NAME NOT NULL VARCHAR2(64) |
|||
NAME_LOWERCASE NOT NULL VARCHAR2(64) |
|||
ALIAS VARCHAR2(64) |
|||
ALIAS_LOWERCASE VARCHAR2(64) |
|||
IP_ADDRESS VARCHAR2(21) |
|||
IF_IP_ADDRESS CHAR(15) |
|||
MTF_NAME VARCHAR2(64) |
|||
ELEMENT_TYPE NOT NULL NUMBER(11) |
|||
LATENCY_PARTNER VARCHAR2(64) |
|||
LATENCY_SOURCE NUMBER(11) |
|||
INDEX1 NUMBER(11) |
|||
INDEX2 VARCHAR2(256) |
|||
INDEX3 VARCHAR2(256) |
|||
INDEX4 VARCHAR2(256) |
|||
SPEED NUMBER(38,7) |
|||
SPEED1 NUMBER(38,7) |
|||
DEVICE_SPEED NUMBER(38,7) |
|||
DEVICE_SPEED2 NUMBER(38,7) |
|||
RESPONSE_LIMIT NUMBER(11) |
|||
POLL_RATE NUMBER(11) |
|||
POLL_TIMEOUT NUMBER(11) |
|||
POLL_RETRIES NUMBER(11) |
|||
COMMUNITY_STRING VARCHAR2(64) |
|||
READ_COMMUNITY VARCHAR2(64) |
|||
STORE_IN_DB NUMBER(1) |
|||
CISCO_PING NUMBER(1) |
|||
REMOTELY_POLLED NUMBER(1) |
|||
MONITOR_LE NUMBER(1) |
|||
FULL_DUPLEX NUMBER(1) |
|||
INC_IN_LW_RPTS NUMBER(1) |
|||
HOSTNAME VARCHAR2(64) |
|||
SYS_NAME VARCHAR2(64) |
|||
SYS_DESCR VARCHAR2(256) |
|||
DISCOVER_KEY VARCHAR2(128) |
|||
VIRTUAL_ID VARCHAR2(32) |
|||
UNIQUE_DEV_ID VARCHAR2(128) |
|||
NMS_KEY VARCHAR2(128) |
|||
NMS_STATE NUMBER(11) |
|||
IF_PHYS_ADDRESS CHAR(17) |
|||
DEVICE_HASH_KEY VARCHAR2(16) |
|||
ELEM_TIMEZONE VARCHAR2(20) |
|||
APP_TYPE NUMBER(11) |
|||
APP_KEY VARCHAR2(64) |
|||
CLIENT_ACCESS NUMBER(11) |
|||
CAPTION VARCHAR2(64) |
|||
USER_STRING VARCHAR2(256) |
|||
IMPORT_MODULE_NAME VARCHAR2(10) |
|||
IMPORT_NMS_HOST VARCHAR2(64) |
|||
CREATE_TIME NOT NULL NUMBER(11) |
|||
MODIFY_TIME NUMBER(11) |
|||
</pre> |
|||
you can use the SELECT command to list detale about elements in a table |
|||
ie. to list the group names and there id numbers from the NH_GROUP table: |
|||
*<pre>SQL> SELECT NAME,GROUP_ID from NH_GROUP |
|||
groupName1 00001 |
|||
groupName2 00002</pre> |
|||
to list all elements with X ip address |
|||
*<pre>SQL> SELECT NAME from NH_ELEMENT where IP_ADDRESS='x.x.x.x'; |
|||
NAME |
|||
---------------------------------------------------------------- |
|||
router-001-Serial0/0-dlci-1 |
|||
router-001-Serial0/0-dlci-2 |
|||
router-001-RH-Cpu-1 |
|||
router-001-RH-Serial0/0 |
|||
router-001-RH-Serial0/1 |
|||
router-001-RH-Ethernet0/0 |
|||
router-001-RH-Ethernet0/1 |
|||
router-001-RH |
|||
8 rows selected. |
|||
</pre> |
|||
[http://uusky.zj.com �?�州网站建设] |
|||
[http://sdxx.zj.com �?�州网络公�?�] |
|||
[http://www.loveday.somee.com/ GOOGLE排�??] |
|||
[http://www.cnzjqi.somee.com 网站建设] |
|||
[http://www.uusky.com/host 网站建设] |
|||
[http://www.uusky.com/webpage/ 网站建设] |
|||
[http://www.uusky.com/inf/ 网站建设] |
|||
[http://www.hzjl365.com/inc/ 网站建设] |
|||
[http://xnan2.91x.net/ 网站建设] |
|||
[http://www.xinyifang.net/inf/ 网站建设] |
|||
[http://web.uusky.org/ 网站建设] |
|||
[http://www.pagerealm.com/agent2732/ 网站建设] |
|||
[http://www.pcpages.com/uusky/ 网站建设] |
|||
[http://www.coolgoose.com/sites/xnane/ 网站建设] |
|||
[http://www.coolgoose.com/sites/xnane/web/ 网站建设] |
|||
[http://www.coolgoose.com/sites/xnane/company/ 网络公�?�] |
|||
[http://www.znpp.com/google/ 网络公�?�] |
|||
[http://uusky.zj.com/company/ 网络公�?�] |
|||
[http://uusky.zj.com/web/ 网络公�?�] |
|||
[http://www.blogcn.com/user20/xnan2 网站建设] |
|||
[http://xnan2.blogdriver.com/xnan2/ 网站建设] |
|||
[http://www.loveday.epsystem.net 网站建设] |
|||
this is a cool link about, [[http://www.stormloader.com/yonghuang/computer/OracleAndPerl.html OracleAndPerl]] |
|||
[http://diary.51122.com �?费申请个人日记] |
|||
[http://gb.51122.com �?费申请留言本] |
|||
[http://www.51122.com/website/ �?�州网页设计] |
|||
[http://www.excce.com/website/ �?�州网站设计] |
Revision as of 00:36, 13 January 2005
中国涂装设备网[http://www.hzn.cn/web/ 网站建设�?�州][http://www.hzn.cn/domain/ �?�州域�??注册][http://www.hzn.cn/email/ �?�州�?业邮局][http://www.hzn.cn/tj/ �?�州网站网络推广]涂装 [http://www.51122.com 世纪网�?�之家] 网站建设 世纪情感 [http://www.uusky.org �?�州网络公�?�] [http://www.uusky.net �?�州喷塑加工]
[http://www.hzn.cn �?�州网站建设] [http://www.hzn.cn �?�州网络公�?�] 情感 [http://www.uusky.org �?�州网站建设] [http://www.znpp.com �?�州网站建设]
[http://uusky.zj.com �?�州网站建设] [http://sdxx.zj.com �?�州网络公�?�] [http://www.loveday.somee.com/ GOOGLE排�??] 网站建设 网站建设 网站建设 网站建设 网站建设 网站建设 网站建设
网站建设
网站建设 网站建设 网站建设 网站建设 [http://www.coolgoose.com/sites/xnane/company/ 网络公�?�] [http://www.znpp.com/google/ 网络公�?�] [http://uusky.zj.com/company/ 网络公�?�] [http://uusky.zj.com/web/ 网络公�?�] 网站建设 网站建设
网站建设 [http://diary.51122.com �?费申请个人日记] [http://gb.51122.com �?费申请留言本] [http://www.51122.com/website/ �?�州网页设计] [http://www.excce.com/website/ �?�州网站设计]