< Concord
Content added Content deleted
No edit summary |
imported>mutante mNo edit summary |
||
(6 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
you can use sql to access Concord's database |
|||
<a href="http://get-nude-girls.com/"> http://get-nude-girls.com/ </a> |
|||
http://get-nude-girls.com/ |
|||
<a href="http://fuck-your-self.com/"> http://fuck-your-self.com/ </a> |
|||
first use the "sqlplus" command to open the SQL commandline interface |
|||
http://fuck-your-self.com/ |
|||
<pre> host# sqlplus user/pass </pre> |
|||
<a href="http://sexy--asians.com/"> http://sexy--asians.com/ </a> |
|||
you can turn off the table headers (this is usefull if you are scripting)<br> |
|||
http://sexy--asians.com/ |
|||
increase the number of pages / lines in each page. |
|||
<a href="http://sexy-photo-pics.com/"> http://sexy-photo-pics.com/ </a> |
|||
<pre>SQL>SQL> set pages 100 lines 1000 head off |
|||
http://sexy-photo-pics.com/ |
|||
SQL> |
|||
<a href="http://funny--sex.com/"> http://funny--sex.com/ </a> |
|||
</pre> |
|||
http://funny--sex.com/ |
|||
<a href="http://sex--winner.com/"> http://sex--winner.com/ </a> |
|||
http://sex--winner.com/ |
|||
you can use the DESCRIBE command to find detales about tables eg: |
|||
<a href="http://sex-in-bmw.com/"> http://sex-in-bmw.com/ </a> |
|||
<pre>SQL> DESCRIBE NH_GROUP; |
|||
http://sex-in-bmw.com/ |
|||
Name Null? Type |
|||
<a href="http://hot-sex-pics-here.com/"> http://hot-sex-pics-here.com/ </a> |
|||
----------------------------------------- -------- ---------------------------- |
|||
http://hot-sex-pics-here.com/ |
|||
GROUP_ID NOT NULL NUMBER(11) |
|||
<a href="http://fucking--sucking.com/"> http://fucking--sucking.com/ </a> |
|||
GROUP_TYPE NOT NULL NUMBER(11) |
|||
http://fucking--sucking.com/ |
|||
MACHINE_ID NOT NULL NUMBER(11) |
|||
<a href="http://sex-on-public.com/"> http://sex-on-public.com/ </a> |
|||
CREATE_TIME NOT NULL NUMBER(11) |
|||
http://sex-on-public.com/ |
|||
MODIFY_TIME NOT NULL NUMBER(11) |
|||
<a href="http://247--sex.com/"> http://247--sex.com/ </a> |
|||
NAME NOT NULL VARCHAR2(64) |
|||
http://247--sex.com/ |
|||
CONTAINER_TYPE NOT NULL NUMBER(11) |
|||
<a href="http://nice-nude-sluts.com/"> http://nice-nude-sluts.com/ </a> |
|||
EXPIRE_TIME NOT NULL NUMBER(11)</pre> |
|||
http://nice-nude-sluts.com/ |
|||
<a href="http://sexy-girl-toying.com/"> http://sexy-girl-toying.com/ </a> |
|||
<pre>SQL> DESCRIBE NH_ELEMENT; |
|||
http://sexy-girl-toying.com/ |
|||
Name Null? Type |
|||
<a href="http://sex-orgy-now.com/"> http://sex-orgy-now.com/ </a> |
|||
----------------------------------------- -------- ---------------------------- |
|||
http://sex-orgy-now.com/ |
|||
ELEMENT_ID NOT NULL NUMBER(11) |
|||
<a href="http://busty--sluts.com/"> http://busty--sluts.com/ </a> |
|||
MACHINE_ID NUMBER(11) |
|||
http://busty--sluts.com/ |
|||
NAME NOT NULL VARCHAR2(64) |
|||
<a href="http://group-sex-dvd.com/"> http://group-sex-dvd.com/ </a> |
|||
NAME_LOWERCASE NOT NULL VARCHAR2(64) |
|||
http://group-sex-dvd.com/ |
|||
ALIAS VARCHAR2(64) |
|||
<a href="http://ass-sex-vids.com/"> http://ass-sex-vids.com/ </a> |
|||
ALIAS_LOWERCASE VARCHAR2(64) |
|||
http://ass-sex-vids.com/ |
|||
IP_ADDRESS VARCHAR2(21) |
|||
<a href="http://sex-for-bucks.com/"> http://sex-for-bucks.com/ </a> |
|||
IF_IP_ADDRESS CHAR(15) |
|||
http://sex-for-bucks.com/ |
|||
MTF_NAME VARCHAR2(64) |
|||
<a href="http://get-world-sex.com/"> http://get-world-sex.com/ </a> |
|||
ELEMENT_TYPE NOT NULL NUMBER(11) |
|||
http://get-world-sex.com/ |
|||
LATENCY_PARTNER VARCHAR2(64) |
|||
<a href="http://sex--mission.com/"> http://sex--mission.com/ </a> |
|||
LATENCY_SOURCE NUMBER(11) |
|||
http://sex--mission.com/ |
|||
INDEX1 NUMBER(11) |
|||
<a href="http://porn-in-life.com/"> http://porn-in-life.com/ </a> |
|||
INDEX2 VARCHAR2(256) |
|||
http://porn-in-life.com/ |
|||
INDEX3 VARCHAR2(256) |
|||
<a href="http://sex-porn-club.com/"> http://sex-porn-club.com/ </a> |
|||
INDEX4 VARCHAR2(256) |
|||
http://sex-porn-club.com/ |
|||
SPEED NUMBER(38,7) |
|||
<a href="http://real-xxx-porn.com/"> http://real-xxx-porn.com/ </a> |
|||
SPEED1 NUMBER(38,7) |
|||
http://real-xxx-porn.com/ |
|||
DEVICE_SPEED NUMBER(38,7) |
|||
<a href="http://crazy--fuckers.com/"> http://crazy--fuckers.com/ </a> |
|||
DEVICE_SPEED2 NUMBER(38,7) |
|||
http://crazy--fuckers.com/ |
|||
RESPONSE_LIMIT NUMBER(11) |
|||
<a href="http://sex--nation.com/"> http://sex--nation.com/ </a> |
|||
POLL_RATE NUMBER(11) |
|||
http://sex--nation.com/ |
|||
POLL_TIMEOUT NUMBER(11) |
|||
<a href="http://ultra-sex-videos.com/"> http://ultra-sex-videos.com/ </a> |
|||
POLL_RETRIES NUMBER(11) |
|||
http://ultra-sex-videos.com/ |
|||
COMMUNITY_STRING VARCHAR2(64) |
|||
<a href="http://blowjob--sex.com/"> http://blowjob--sex.com/ </a> |
|||
READ_COMMUNITY VARCHAR2(64) |
|||
http://blowjob--sex.com/ |
|||
STORE_IN_DB NUMBER(1) |
|||
<a href="http://cock--sex.com/"> http://cock--sex.com/ </a> |
|||
CISCO_PING NUMBER(1) |
|||
http://cock--sex.com/ |
|||
REMOTELY_POLLED NUMBER(1) |
|||
<a href="http://anal--lovers.com/"> http://anal--lovers.com/ </a> |
|||
MONITOR_LE NUMBER(1) |
|||
http://anal--lovers.com/ |
|||
FULL_DUPLEX NUMBER(1) |
|||
<a href="http://hardfucking-sluts.com/"> http://hardfucking-sluts.com/ </a> |
|||
INC_IN_LW_RPTS NUMBER(1) |
|||
http://hardfucking-sluts.com/ |
|||
HOSTNAME VARCHAR2(64) |
|||
<a href="http://after-party-sex.com/"> http://after-party-sex.com/ </a> |
|||
SYS_NAME VARCHAR2(64) |
|||
http://after-party-sex.com/ |
|||
SYS_DESCR VARCHAR2(256) |
|||
<a href="http://sexy--nurses.com/"> http://sexy--nurses.com/ </a> |
|||
DISCOVER_KEY VARCHAR2(128) |
|||
http://sexy--nurses.com/ |
|||
VIRTUAL_ID VARCHAR2(32) |
|||
<a href="http://perfect--sex.com/"> http://perfect--sex.com/ </a> |
|||
UNIQUE_DEV_ID VARCHAR2(128) |
|||
http://perfect--sex.com/ |
|||
NMS_KEY VARCHAR2(128) |
|||
<a href="http://mature-sex-action.com/"> http://mature-sex-action.com/ </a> |
|||
NMS_STATE NUMBER(11) |
|||
http://mature-sex-action.com/ |
|||
IF_PHYS_ADDRESS CHAR(17) |
|||
<a href="http://bdsm--sex.com/"> http://bdsm--sex.com/ </a> |
|||
DEVICE_HASH_KEY VARCHAR2(16) |
|||
http://bdsm--sex.com/ |
|||
ELEM_TIMEZONE VARCHAR2(20) |
|||
<a href="http://incest--lovers.com/"> http://incest--lovers.com/ </a> |
|||
APP_TYPE NUMBER(11) |
|||
http://incest--lovers.com/ |
|||
APP_KEY VARCHAR2(64) |
|||
<a href="http://young--fuckers.com/"> http://young--fuckers.com/ </a> |
|||
CLIENT_ACCESS NUMBER(11) |
|||
http://young--fuckers.com/ |
|||
CAPTION VARCHAR2(64) |
|||
<a href="http://very-sex-ladies.com/"> http://very-sex-ladies.com/ </a> |
|||
USER_STRING VARCHAR2(256) |
|||
http://very-sex-ladies.com/ |
|||
IMPORT_MODULE_NAME VARCHAR2(10) |
|||
<a href="http://fucking--pussy.com/"> http://fucking--pussy.com/ </a> |
|||
IMPORT_NMS_HOST VARCHAR2(64) |
|||
http://fucking--pussy.com/ |
|||
CREATE_TIME NOT NULL NUMBER(11) |
|||
<a href="http://my-sexy-syster.com/"> http://my-sexy-syster.com/ </a> |
|||
MODIFY_TIME NUMBER(11) |
|||
http://my-sexy-syster.com/ |
|||
</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> |
|||
this is a cool link about, [[http://www.stormloader.com/yonghuang/computer/OracleAndPerl.html OracleAndPerl]] |
|||
[[Concord|Back to Concord Index]] |
|||
[[Category:Concord]] |
|||
[[Category:Computer]] |
|||
[[Category:English]] |
Latest revision as of 09:19, 10 September 2006
you can use sql to access Concord's database
first use the "sqlplus" command to open the SQL commandline interface
host# sqlplus user/pass
you can turn off the table headers (this is usefull if you are scripting)
increase the number of pages / lines in each page.
SQL>SQL> set pages 100 lines 1000 head off SQL>
you can use the DESCRIBE command to find detales about tables eg:
SQL> DESCRIBE NH_GROUP; Name Null? Type ----------------------------------------- -------- ---------------------------- 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)
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)
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:
SQL> SELECT NAME,GROUP_ID from NH_GROUP groupName1 00001 groupName2 00002
to list all elements with X ip address
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.
this is a cool link about, [OracleAndPerl]