Concord/Sqlplus

you can use sql to access Concord's database

first use the "sqlplus" command to open the SQL commandline then you can use the DESCRIBE command to find detales about tables eg: 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_GROUP;

next to list the group names and there id numbers from the NH_GROUP table: groupName1     00001 groupName2     00002
 * SQL> SELECT NAME,GROUP_ID from NH_GROUP